How do I import my inventory? What file formats do you support?
There are really two different answers to this question.
Importing from E-Commerce Systems. Well, actually, just syncing.
If you are setup to integrate with an e-commerce platform that we support, such as Shopify or Magento, and all your inventory is already in those systems, then you don’t need to import anything into Bizelo. Simply click on the “sync” button that you see when you mouse-over a store with e-commerce integration support. Once you do that, you’ll get a sync screen that will bring in any new / changed products as well as reset any available quantities that we have for inventory that already exists (based on the SKU):
If you don’t see a sync button and you have an e-commerce system that we support, it’s because you haven’t set up your store yet (or haven’t completed the setup). See here for FAQs on how to set up Stores for e-commerce integration.
Importing from a CSV file
If you have items you want to import that are not in your e-commerce system, or you aren’t integrated with an e-commerce system, you can import your items using the CSV file format. CSV stands for “Comma Separated Values” and it just means that its a text file that is formatted using a specific approach, with commas separating data values and quotes used to encapsulate data entries. Many programs support saving CSV files including most text editors and most importantly Microsoft Excel.
Before we get into the import process, we first have to make an important note: Bizelo uses the CSV process to import items into our own systems. However, we do not in turn push inventory into any connected e-commerce systems! This is because we only support a subset of the data needed by ecommerce storefronts — the part dealing with inventory. If you want to get your data into your e-commerce system, you have to first import it there. Then use the Sync approach we list above to in turn get that data into Bizelo IPS.
Bizelo has a CSV importer that uses three steps to get your data into our system.
Step 1: Go to Inventory -> Import and Upload your CSV File
Click on the “Inventory” green navigation tab near the top of the page and select the “Import” option on the right blue side bar. You will be presented with a screen that asks you to upload your CSV file. If you have used traditional CSV defaults, then this is pretty much all you need to do. If you have a specific format that uses different delimeters or text encapsulation, you can seleect the “advanced options” opener and it should prompt you for specifics.
Also, note that you can specify the date on which the inventory quantities reflected in your CSV file are for. For example, if you’re uploading inventory from a week ago so you can support orders that have come in since that time, specify the date in the Date box and upload your inventory. You can then pick your orders from this inventory and your final numbers will reflect your quantities as they are in effect as of the current date.
Once you complete this step, you will be prompted to map the fields in your CSV file to fields that Bizeo supports. Please note that you must have the “SKU” field set up and at least one item detail field, such as a product name or quantity.
Once this step is completed, the file will either be imported successfully, or you’ll see an error message detailing the steps to be corrected. If you have any problems with your CSV import, please let us know by submitting a Support Ticket at http://support.bizelo.com
Importing from an XML file
At this time, Bizelo supports XML (eXtensible Markup Language) file importing on a case-by-case basis. This is because while XML is a standard, it’s particularly flexible (hence why it’s called extensible). This means that no two XML formatted documents are the same — not only in data, but in structure. XML allows unlimited levels of nesting, repeated elements, and even optional elements. Anything can and does go with XML files, which is why we (or anyone) can’t generically support XML. We have to first get a copy of the XML file you wish to import and then set up a specific filter for you. Because this is a manual process, we charge a one-time $49 fee to set up an XML import filter for you. As long as your XML format doesn’t change, you won’t need to ever pay this fee again.