Zen Cart Sellbrite Integration
Do you want to use Sellbrite so that your Internet based business can sell on multiple channels in addition to Zen Cart?
Come work with me and I'll help you!
I created a set of Zen Cart tools which import and export product data between the Zen Cart database and Sellbrite. There are four components:
- Import products from Sellbrite
- Export products to Sellbrite
- Updating inventory in Zen Cart from Sellbrite
- Modify Sellbrite inventory after a Zen Cart sale
Import from SellbriteAn import from Sellbrite will either create a new product in Zen Cart or update an existing product. To prepare for an import from Sellbrite into Zen Cart, first export your products from Sellbrite, using Settings->Application Settings->Export Data.
Here is the mapping I used. This can be changed for your unique situation, and of course, the Sellbrite Custom Attributes will be yours.
(Table aliases: p = products; pd = products_description, sb = sellbrite.)
|Product Image 1||p.products_image|
|Custom Attribute 1||sb.custom_attribute_1|
|Custom Attribute n||sb.custom_attribute_n|
The default category id for new products is a holding category the products are placed in until you organize them in your store. Images 2-12 (if specified) are also imported to your store, using the Zen Cart image naming convention.
Export to SellbriteExporting to Sellbrite allows you to populate Sellbrite with the products which are currently in your Zen Cart store. It creates a CSV file in the format of the Sellbrite Inventory CSV import template, which you can import into Sellbrite using Settings->Application Settings->Import Data.
Updating inventory in Zen Cart from SellbriteUpdating your Zen Cart p.products_quantity field from the Sellbrite available field is done using the Sellbrite API. This process is run on your site using
crononce an hour, or more frequently for high volume operations.
Modify Sellbrite inventory after a Zen Cart saleA hook is added to your store so that after a sale, the inventory in Sellbrite is updated using the Sellbrite API.
This software is offered to my support clients only. Would you like to improve your sales using the multi-channel capabilities of Sellbrite? Come work with me and I'll help you!