an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > Documentation > Online Help > Product Management > Bulk Import > Product Bulk Import File Format
Product Bulk Import File Format
Product bulk import file format is basically a tab delimited text file. You can find the sample import file from here.
 
The file with the column headers is pretty much self-explain. Make sure you need to have all the columns separated by tabs even if the columns are empty. If you have SKU defined, the bulk import process is going to check if there is existing product with the same SKU. If so, the existing product is updated. If not, a new product is created. So you could use bulk import process to bulk updated product stock level if you fill out the SKUs.
 
Here are some notices to certain columns.
 
1) Category
You could separated multiple category levels by using the special character ":". For example if you put Barrettes:Crystal, it would create Barrettes category if it doesn't exist and then create the sub category Crystal as a child of Barrettes category.
 
2) Image_Urls
You could separated multiple product image Urls by using comma. For example if you put http://domain.com/image1jpg,http://domain.com/image2.jpg, two images will be created for the product and first one will be the default product image. 
Either when I copy the browser text, or save the unicode file, I cannot get this example correctly displayed in Excel in Colums.
Could you please provide a better table example to download. Or explain me what I am doing wrong here.... <img alt="" src="http://www.dotshoppingcart.com/FCKEditor/editor/images/smiley/msn/confused_smile.gif" />
Also I would like to know whether and how following works in Bulk-Upload:
- to assign a single product to multiple categories in Bulk Upload ( done with comma's like URL's?)
- to assign multiple attributes to one product ( done with comma's like URL's?)
 
For me these two are key Need-To-Haves, since my business requires thousands of products to be uploaded. Each product has a generic set of Attributes (5-9) that I need to link without the "Attribute Typing" for each product in Product-Edit.  In this case it would be nice to have Pre-Defined Attribute Tables/Sets that can be assigned easily per product either in Bulk Upload or Product-Edit.
 
Looking forward to your reply.
Gijs,
 
Don't copy the text from the browser. Instead right click the here link and select "Save Target As...". And then open it from Excel.
 
Assigning multiple categories is not supported currently. It will be supported in the next release.
 
Please follow the sample import file line 3 to 5 for how to assign multiple attributes to a product. Basically you need to put the attributes in the lines below the product.
 
Hi Luke,
 
I am facing a small issue with the bulk import. In the previous 3.00 version, the bulk import handled the categories exactly the way it should have. That is for eg:
 
<span style="font-family: Times New Roman;">Barrettes:Crystal</span>, it created the main category barrettes and sub category crystal.
 
In the new version, it creates the category as <span style="font-family: Times New Roman;">Barrettes:Crystal </span>without creating the main and subs respectfully. Is there a new seperator i am unaware of? Do let me know.
 
Thanks in advance
 
 
Ah, it's a regression bug. The fix has been pushed to the next version. You can download this and replace the one in orderpipeline.
Hi Luke,
 
Thanks for the quick response.
 
 
Hi Luke,
 
The Bulk Import feature iterates through my file, and corrects me where there are issues.  Once all of the issues are resolved, the file says that its completed importing the files, but none of the products show.  And the Log does not display any errors.
 
Any thoughts?
The actual importing process is done via OrderPipeline. Is your OrderPipeline running?
How do I find the order pipeline?  I am trying to import records but the log is empty and it looks like the process is not firing.
 
Thanks,  Frank
<table id="ctl00_ContentPlaceHolder1_lvwImports_tableListView" class="gridViewTable"> <tbody> <tr> <th><a id="ctl00_ContentPlaceHolder1_lvwImports_LinkButton1" href="javascript:__doPostBack('ctl00$ContentPlaceHolder1$lvwImports$LinkButton1','')">BulkImportId</th> <th><a id="ctl00_ContentPlaceHolder1_lvwImports_LinkButton2" href="javascript:__doPostBack('ctl00$ContentPlaceHolder1$lvwImports$LinkButton2','')">Time Created</th> <th>Processed</th> <th>Uploaded</th> <th>Log</th> </tr> <tr id="ctl00_ContentPlaceHolder1_lvwImports_ctrl0_tableRowListView"> <td>1</td> <td>2/10/2010 8:47:45 PM</td> <td> </td> <td> </td> <td>Show Log </td> </tr> <tr class="pagerstyle"> <td id="ctl00_ContentPlaceHolder1_lvwImports_tablePagerListView" colspan="5"><span id="ctl00_ContentPlaceHolder1_lvwImports_dataPager"><span>Go to : </span><input onkeypress="if (WebForm_TextBoxKeyHandler(event) == false) return false;" onchange="javascript:setTimeout('__doPostBack(\'ctl00$ContentPlaceHolder1$lvwImports$dataPager$ctl00$ctl01\',\'\')', 0)" style="width: 20px" name="ctl00$ContentPlaceHolder1$lvwImports$dataPager$ctl00$ctl01" type="text" />  Show rows : <select onchange="javascript:setTimeout('__doPostBack(\'ctl00$ContentPlaceHolder1$lvwImports$dataPager$ctl00$ctl02\',\'\')', 0)" name="ctl00$ContentPlaceHolder1$lvwImports$dataPager$ctl00$ctl02"> <option value="10" selected="selected">10</option> <option value="25">25</option> <option value="50">50</option> <option value="100">100</option> <option value="250">250</option> <option value="500">500</option> </select>  1 - 1 of 1   <input class="previous" title="Previous Page" type="submit" name="ctl00$ContentPlaceHolder1$lvwImports$dataPager$ctl00$ctl03" value="Submit Query" /> <input class="next" title="Next Page" type="submit" name="ctl00$ContentPlaceHolder1$lvwImports$dataPager$ctl00$ctl04" value="Submit Query" /> </span></td> </tr> </tbody> </table>
OrderPipeline is a Windows service that you install in the step 6 of the installation guide.
More Resources
Quick Links