Zen Cart to Salesforce Prices Import
So now you have your products in Salesforce, you think you're home free, right? Wrong-o! You have to set product prices, which is yet another step!
And guess what - just like products, prices are not on the Data Import Wizard. So how do you import them?
Actually, it's easy: come work with me and I'll help you!
Once you have imported your products, we have to go to Zen Admin, and export prices. Use Salesforce Export Prices from your Zen Cart Admin Tools menu. It creates a file called prices.csv.
As in the case of importing products, to import the prices CSV into Salesforce, I use dataloader.io, which creates Price Book Entry objects. You can read about importing using dataloader.io if you're new to it.
Here's the mapping I used:
Salesforce | Zen Cart |
---|---|
Price Book ID | 18 character Salesforce ID of your Standard price book |
Price Book Entry ID | p.products_model on insert |
Product2Id | p.products_model on update |
List Price | p.products_price |
Active | Y |
There are two things to know about the Price Book Entries:
- We can't automatically map all of our fields. Instead, we have to use the trick that was mentioned on the products page of using the Product Code as the identifier.
- Price Book Entries cannot be upserted. This is a restriction of Salesforce. So this means you have to Import entries for new products, which do not yet have standard prices, and Update entries for existing products when it's time to update. This makes the process of setting prices a bit more confusing than creating customers and products.
The way most people create a standard price is to press the "Add Standard Price" button on the Related screen for their new product.
But you wouldn't want to do this for hundreds of products. Fear not! That Software Guy to the rescue! Here's how you can Insert Standard Prices (for product that don't have them) and Update Standard Prices (for products that do).
Dataloader.io Insert for Price Book Entries
First, run the Salesforce Export Prices tool from Zen Cart. Then, you'll want to do an Insert for new products which do not yet have standard prices. Here, you want to look up the Product2Id field from the model number.In dataloader.io, click New Task, then Import, and select the Price Book Entry Object, then click Next.
Dataloader.io Update for Price Book Entries
This is what you want to do for existing products which already have standard prices. Here, you want to look up the Price Book Entry ID field from the model number.You can update as many times as you want, but when you insert, you will get errors for the products that already exist. This is harmless - it's just a bit shocking at first. Here's the dataloader.io error from doing an insert for one new product with 80 existing products in my prices.csv file.
Now you can avoid these errors by editing prices.csv and just removing older products which have prices, but it's really not necessary; the message is harmless.
Now when you look at the Related screen for the new product, the "Add Standard Price" button is no longer there, and instead, there is a reference to the Standard Price Book.
So to recap:
- On an insert: look up the Product2Id field
- On an update: look up the Price Book Entry ID field
For prices, there is no incremental import; the Zen Cart Salesforce Export Prices tool exports all product prices (because it doesn't know whether you're doing an insert on new product prices or an update for existing ones).
Once the price on a product is set, you can see it on the detail tab, as is shown in the image above. Also, as noted in importing products, you can use VisualForce to display the price on the Product Details page.
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!