an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Using DotShoppingCart > Bulk Import Problem on V4
Bulk Import Problem on V4
Last Post 3/26/2010 9:53:12 AM By Bahram. 18 replies.
Page 1 of 2 (19 posts) << First < Prev 1 2 Next > Last >> 
3/17/2010 3:25:49 PM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Bulk Import Problem on V4
I made a new BulK Import file for a new Category (Parameters) All of the products under sub Categories of this new category are all ready in the system.
 
So my Question is : Can a Product be under Two or more categories?
 
If yes then why Bulk Import process is updative rather than incremental. It seems Bulk import overwrites the existing categories with new categories.
 
Also  a new bulk Import  does not work properly and aborts if it has existing products under new additional Categories.
 
These are the problems of running Bulk import for a new Category
 
1- The images will not show for the products imported
2- The products are deleted or updated on productCategory_map since the pair (productId, categoryId) is unique
3-The OrderPipeline aborts and crashes.
 
 
3/18/2010 10:38:03 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Bulk Import Problem
Are you using the same SKUs for the products that you were importing?
DotShoppingCart Staff
3/18/2010 10:59:26 AM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Bulk Import Problem
 Yes the same SKUs
 
This is the continuation of the case of creating a new Entity called Application and binding products to it. Your solution was to create a new category and sub categories.
but we will have the same products ( Sku) under this category and subs.
 
It seems that on product (sku) can not be in two categories at the same time. Is it True?
 
 
 
 
3/18/2010 11:54:47 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Bulk Import Problem
One product can belong to multiple categories. If you pass the same SKU, the bulk import behavior is update (replacement). It replaces with whatever you specific in the bulk import file. If you specify just one category it will use that category for that product. If you don't specify images it will remove any existing images. If you wish it to be in multiple categories, please specify that in the bulk import file.
DotShoppingCart Staff
3/18/2010 12:44:49 PM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Bulk Import Problem
 Now we are back again to the point of Testing Bulk Import, this time for V4.
 
Things are not working as you stated or expected. I deleted all Category, products, etc and two merged the Import files into one.
 
Bulk Import splits the products into multiple categories i.e.
 
I have this 
 
Data Loggers:SmartReader Plus ......... 56 Products of this Category
 
Parameter:Temperature                           13 Products of the above
Parameters:Pressure                               14 Products of the above 
Parameters:Process Signal                     13 Products of the above
Parameters:Pulse                                        2 Products of the above
 
At the end I have only 14 products under the Data Loggers:SmartReader Plus instead of 56
14 = 56 -(13+14+13+2)
 
and I have no image of the products too  
 
 
I also have a top level Category for SmartReader Plus (second level) with 30  products. 
 
All the data was in one import file and BulK import distributed data (product with same sku) under new categories it found, instead of creating new category-product-mapping record.
 
The procedure also lost the trace of the categories that created two top Level categories for two second level categories.
3/18/2010 12:57:45 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Bulk Import Problem on V4
Please take a look at the online doc again. The first bullet describes how to specifiy muiltple categories for one product. If you don't provide image url in the bulk import why don't you expect product images to show?
DotShoppingCart Staff
3/18/2010 1:07:40 PM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Bulk Import Problem on V4
 All the products have image urls. my issue is not images at this time. if you read my case. Bulk import totally screws everything in just one batch file.
 
1- It updates SKUs in newer categories it finds, instead of creating new records for (categoryid,productid)
2- It creats new top level category for second level and asigns skus to it.
3/18/2010 1:12:48 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Bulk Import Problem on V4
This is by design. Please read my previous replies.
DotShoppingCart Staff
3/18/2010 3:14:37 PM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Bulk Import Problem on V4
Hi Luke,
 
This is not my first bulk Import, we already have codes  to generate query results according to that format.
The bulk import do not act according to your own specs.
 
 
Thanks,
3/18/2010 3:30:01 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Bulk Import Problem on V4
I don't see how it's not working according to the spec. Or you didn't explain well. Try posting one line of product import file and describe what's not working according to the spec.
DotShoppingCart Staff
3/18/2010 4:07:47 PM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Bulk Import Problem on V4
 Does all those explanation are meaningless , see the three previous posting that is full description of the case:
 
Smart Reader Plus is a Category Level 1 with 52 SKUs
 
The Bulk import will split these SKUs in another Categories.
 
As I sent you the Image by email. The Smart Reader Plus is now a Level 0 Category with 30 Sku
 
Also a Three Level Category is now shown as Two levels and Skus are combined.
 
This Bulk Import is not the V3.1 that we have tested and debugged for you.
 
 
 
 
Page 1 of 2 (19 posts) << First < Prev 1 2 Next > Last >> 
Project hosted at CodePlex.com
Copyright © 2013 DotShoppingCart. All rights reserved.