Zen Cart custom software development, Zen Cart modules, Zen Cart Expert eCommerce with Zen Cart!

Zen Cart to Salesforce Products Import

Getting your Zen Cart data into Salesforce starts with import your customers from Zen Cart to Salesforce. And many people stop there too! In particular, with the lower editions (such as Salesforce Essentials), you can't produce quotes, so you don't need product data. But if have the Professional Edition, and you want to do more with Salesforce, you'll need to set up your product list.

Now you'd think that products would be on the Data Import Wizard, but surprise - they're not! So how do you import them?

Actually, it's easy: come work with me and I'll help you!    Let's get started!

I created a Zen Cart tool which exports product data from the Zen Cart database into a CSV for import into Salesforce. It's called Salesforce Export Products, and it's available from the your Zen Cart Admin Tools menu. It creates a file called products.csv.

Zen Cart Tools menu showing Salesforce options

To import the products CSV into Salesforce, I use dataloader.io, which creates Product objects. You can read about importing using dataloader.io if you're new to it.

Here is the mapping I used. (Table aliases: p = products; pd = products_description.)

SalesforceZen Cart
Store Product ID
A custom field defined as an External ID
Product Namepd.products_name
Product Codep.products_model
Product FamilyUser Defined
Product Descriptionpd.products_description
Marketing URLpd.products_url

In dataloader.io, click New Task, then Import, and select the Product Object, then click Next. Do an upsert.io so new records will be inserted but existing records will be updated, so there's no duplication. Since you don't have the Salesforce ID for your product records, you want to match on the Store Product ID.

Dataloader.io Upsert for Products with Product ID Match

Dataloader.io Upsert of Zen Cart Products with Model Number Match

Alternatively, you could match on the model number (which is called Product Code in Salesforce). Note: The use of products_model as a unique identifier is facilitated by the use of my mod Find Duplicate Models.

Dataloader.io Upsert of Zen Cart Products with Model Number Match

Once the update is done, you'll get a success message from dataloader.io:

Dataloader.io Showing Successful Load

Salesforce Dataloader.io loads Products into Salesforce

Going back to Salesforce, here's what my Zen Cart product data looks like in Salesforce Lightning:

Salesforce Showing Zen Cart Product Data

Zen Cart Products in Salesforce

Export is incremental, so once you have done an initial export, only new or changed records are exported. No CSV is produced if there are no new or changed records.

Incremental Export of Zen Cart Product Data

Zen Cart Incremental Export to Salesforce

Once a product is all set up and, the details page looks like this:

Product Detail Page

Salesforce Product Details page

You'll notice the price appears on the detail page; this is a little bit of VisualForce logic on the Product Details page. Of course, it also depends on setting product prices, which we'll do in the next step: Zen Cart Products Prices to Salesforce.

If you're a developer, you can access the source for these scripts: just go to Zen Cart to Salesforce on Github. And if you're not, come work with me and I'll do it for you!