Pulling Old data from SF

I think everything in that similar issue still applies, but also consider this thread which might be more helpful. Use it alongside the plugin’s import/export documentation, if that is applicable.

So basically we are new to the Salesforce Developer option and currently it seems like Developer option won’t let us to APEX triggers and I’m also not sure how to go about the APEX code solution introduced there. Do you have any recommendations?

Also as for the json approach. So we deleted most of the accounts from WP that we had but once I do an export data, there’s already a lot of data left. We cleared the cache and everything but I’d assume if we clear out the data, the export option shouldn’t have anything. But it has as follows:

...{
      "id": "7938",
      "wordpress_id": "2273",
      "salesforce_id": "sfIDMasked",
      "wordpress_object": "cohorts",
      "created": "2022-10-27 14:08:18",
      "object_updated": "2022-05-03 19:41:44",
      "last_sync": "2022-05-03 19:41:44",
      "last_sync_action": "pull",
      "last_sync_status": "1",
      "last_sync_message": "Mapping object updated via function: update_called_from_salesforce"
    },...

Let’s say we take the json approach, how are we going to know what id to put and what the wordpress Id should be? What i’m thinking is I insert a random wp id or continue where the current export ends? Or do you think if I override existing data, then coming up with a WP Id and ID shouldn’t be a problem? Also does the created have to align with what is on SF or can we just put today’s date and it will work fine? Can you explain what the json structure actually is? I’m sorry but i’m totally new to this but this is kind of stopping us from moving forward with pulling back all the existing data we already have.

Well, to be clear, syncing pre-existing data is not what the plugin is built for. It was designed to sync data after it has been installed. Because the kind of work you’re hoping to do is really not built into the plugin, it’s not something I can provide a lot of customized support for in this forum. I’m happy to link to other solutions people find like the Apex one, but I don’t really offer much more than that here. And certainly I don’t offer Apex support, there are other places to get that.

To your last question, if you’re trying to create new WordPress IDs from existing Salesforce records, I’m not sure you’ll be able to do that with this plugin at all, unless you can update those Salesforce records and have them sync as updated records (which is really what the Apex solution does). What I’ve seen the json do is connect existing Salesforce records to existing WordPress records, I really haven’t seen it used to create new ones (but if it works, feel free!).

Okay so I think I found a solution to get old existing data if we are using Custom Post Types Plugin. We can change the plugin update trigger to System ModStamp and then go to salesforce to make a small change in the existing data which triggers the Object Sync Plugin to pull in those data fields.

Now the reason why I wasn’t able to pull in old data was because previously I had those data but then proceeded to delete them for my own reasons. Now wordpress was storing those under a wordpress object through the custom post type plugin. And for some reason that data doesn’t get deleted from the wp backend even if you don’t see those account. But this is another plugin issue and your plugin works just fine. Thank you for the support!