Creating and updating product records via spreadsheets tests the patience of even the most unflappable eCommerce merchant. “Handy” is probably not a word that you’ll ever hear used to describe spreadsheets. Sadly, eCommerce sellers haven’t had much choice in the matter because spreadsheets are how their supply chain shares products with them. Hold on. Make that were….
Venzee is a new method of working with and transforming data that’s going to being revolutionary change to the way you create and update products for osCommerce. Say goodbye to heavy spreadsheet use and hello to faster creating and updating!
How Venzee works:
Step 1: Sign Up Here In Under A Minute
Sign up for Venzee takes just a few seconds, and doesn’t require a credit card. When you’re done you can start uploading your Source Data to Venzee right away!
Step 2: The osCommerce Template
Think of the osCommerce template as your Venzee-powered magic wand. You will use it to transform your Source Data into dynamic products that are compatible with the osCommerce platform. First, we have to select it though. So…
Click on Dynamic Data and then the “Add” button. This will take you to our Template Library where the osCommerce template is waiting for you. When you find it, select it and click “Next”.
Step 3: Create A Dynamic Collection
Now that you have selected the osCommerce template the next step is creating a Dynamic Collection. This is a simple, one-time process (unless the format of your Source Data changes) that involves mapping the fields in the osCommerce template with the attributes in the Source Data that you uploaded in Step 1. If you want some assistance click on the “?” for pointers.
You can also take advantage of some pretty nifty advanced features like the ability to add padding in order to make your products look better on the osCommerce platform, do math, or make tables.
Click “Generate” when you’re done. Click “Export”, follow the instructions, and we’ll send you an email with a download link for the Dynamic Collection. You will use this file to quickly make osCommerce-ready products for your store.
Step 4: Enjoy Life. Enjoy Venzee!
Congratulations! Your eCommerce life is going to be a lot easier from now on. The products you just created are not only 100% compatible with osCommerce but dynamic as well. That means that whenever someone makes an update to your Source Data your new osCommerce-compatible products are updated as well!
Whenever someone makes an update to your source data your osCommerce-compatible products are updated as well!
Founded over 12 years ago osCommerce is a free, open source eCommerce platform that has created hundreds of thousands of stores around the world. We’re excited about the chance to work with a group of self-described geeks who are passionate about eCommerce and look forward to a win-win relationship!