an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Using DotShoppingCart > Bulk Import Problem on V4
Last Post 3/26/2010 9:53:12 AM By Bahram. 18 replies.
Page 2 of 2 (19 posts) << First < Prev 1 2 Next > Last >> 
3/19/2010 9:27:48 AM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Bulk Import Problem on V4
The reason it does not act according to spec is that it has bugs.These are the summary bugs of Bulk Import V4, in one Batch file.
 
1- It can not create an SKU under  multiple categories, once it sees the same SKU for new Category, it updates the existing one.
2- It fails to created 3 level cateory, and put all SKUS of level 3 under parent of level 2
3- It Creates Level 0 cateegory for some other Level 1 categories.
 
 
 
 
 
3/19/2010 9:55:41 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Bulk Import Problem on V4
If you want us to further investigate this issue, please provide
1) one line of product import file
2) describe what's not working for that product
 
We need simple reproduce steps. It's better than a thousand words.
DotShoppingCart Staff
3/19/2010 10:54:53 AM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Bulk Import Problem on V4
These Three level Categories is created as two level with all SKUs that level</span>
 
Data Loggers:Miscellaneous Loggers and Monitors:TRH TRH-1000 -- Logger Only            </span>
Data Loggers:Miscellaneous Loggers and Monitors:IAQ  Telaire-7001                                                                                                                   </span>
Data Loggers:Miscellaneous Loggers and Monitors:IAQ  SR-IAQ 01-0340 Five channel, 8 bit, 32 KB data logger (One ambient temperature and RH, one CO2, and one external RH & Temperature Channel).      999       885.00  ACR Systems Inc          0            </span>
Data Loggers:Miscellaneous Loggers and Monitors:IAQ  IAQ-101 System            </span>
Data Loggers:Miscellaneous Loggers and Monitors:IAQ  I</span>
 
 
Pulse is never created  at all:</span>
Parameters:Pulse          SmartReader Plus 9 - 32 KB       01-0016</span>
Parameters:Pulse          SmartReader Plus 9 - 128 KB     01-0130</span>
 
Co2-Gases is not created at all</span>
Parameters:CO2-Gases SR-IAQ 01-0340</span>
 
This Category and SKUs never created at all:</span>
Parameters:Power Quality PowerWatch - North American 120V 01-0066 </span>
Parameters:Power Quality PowerWatch - United Kingdom 220V 01-0200</span>
Parameters:Power Quality PowerWatch - European Shuko 220V 01-0215 </span>
Parameters:Power Quality PowerWatch - Australian 220V 01-0205 </span>
 
Whole line is :
Parameters:Power Quality PowerWatch - North American 120V 01-0066 Power quality analyzer/event recorder (120 Volt, North American plug style). 999 599.00 ACR Systems Inc 0 http://procyon/eStore/Images/Products/01-0066_Front_Left_To_Rightw1[Front 1].JPG,http://procyon/eStore/Images/Products/01-0066_Front_Right_To_Leftw2[Front 2].JPG,http://procyon/eStore/Images/Products/01-0066_Frontw3[Front 3].JPG,http://procyon/eStore/Images/Products/01-0066_Leftw4[Left Side].JPG,http://procyon/eStore/Images/Products/01-0066_Rightw5[Right Side].JPG,http://procyon/eStore/Images/Products/01-0066_Topw6[Top].JPG,http://procyon/eStore/Images/Products/01-0066_Bottomw7[Bottom].JPG,http://procyon/eStore/Images/Products/01-0066_Backw8[Back].JPG          
Parameters:Power Quality PowerWatch - United Kingdom 220V 01-0200 Power quality analyzer/event recorder (220 Volt, United Kingdom plug style). 999 640.00 ACR Systems Inc 0 http://procyon/eStore/Images/Products/01-0200_Front_Left_To_Rightw1[Front 1].JPG,http://procyon/eStore/Images/Products/01-0200_Front_Right_To_Leftw2[Front 2].JPG,http://procyon/eStore/Images/Products/01-0200_Frontw3[Front 3].JPG,http://procyon/eStore/Images/Products/01-0200_Topw6[Top].JPG,http://procyon/eStore/Images/Products/01-0200_Bottomw7[Bottom].JPG,http://procyon/eStore/Images/Products/01-0200_Backw8[Back].JPG      </span>
 
 
 
 
3/22/2010 11:07:24 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Bulk Import Problem on V4
Try putting one line product in the bulk import file and then run it one by one and verify the result. Stop the first one that you see a problem. And then provide this line of product . You got to help us to understand your issue. We cannot fix what we don't know.
DotShoppingCart Staff
3/22/2010 12:06:24 PM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Bulk Import Problem on V4
 Hi Luke,
 
It is impossible to test one line by one line, As we already know the problem
 
I did tested more than 10 times. And I posted a Summary Report. The problem of Bulk Import in V4 is:
 
It Can not create the same product (SKU) under another Category 
It can not create Level2 ( 3rd level ) Subcategories
It creates root Categories for some level1 Categories 
 
 
This report with the sample data that creates the errors is the best way you can debug.  
 
 
3/23/2010 10:25:29 AM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Bulk Import Problem on V4
You can do two simple tests:
 
1- Just try to have a product (SKU ) under two or more Differenct categories and see how it works:3 lines of data
2- Try to have a 3 level category product : 2 line of data.
 
3/24/2010 10:20:04 AM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Bulk Import Problem on V4
Hi Luke,
 
 
I did another test and this time I did the V3.1 import file. That is no duplicate  Skus for categories.
 
- No Level 3 Category is created.
- Level 1 category are created as Level 0
- Orderpipeline Service crashes.
 
It is obvious bugs and deffects in V4 Bulk Import.
 
This is the data lines for your Info :

Data Loggers:Miscellaneous Loggers and Monitors:TRH TRH-1000 -- Logger Only 01-0198 2-channel, 8 bit, 64 KB data logger (One ambient temperature and one ambient RH channel). Data logger only, software not included. 999 299.00 ACR Systems Inc 0          
Data Loggers:Miscellaneous Loggers and Monitors:TRH TRH-1000 USB Starter Pack 01-0194 2-channel, 8 bit, 64 KB data logger (One ambient temperature and one ambient RH channel). Includes software, serial to USB adapter cable and manual. 999 319.00 ACR Systems Inc 0          
Data Loggers:Miscellaneous Loggers and Monitors:IAQ Telaire-7001 35-0034 CO2 monitor. Logger sold separately. 999 772.00 ACR Systems Inc 0          
Data Loggers:Miscellaneous Loggers and Monitors:IAQ SR-IAQ 01-0340 Five channel, 8 bit, 32 KB data logger (One ambient temperature and RH, one CO2, and one external RH & Temperature Channel). 999 885.00 ACR Systems Inc 0          
Data Loggers:Miscellaneous Loggers and Monitors:IAQ IAQ-101 System 01-0338 CO2 monitor with temperature, RH and CO2 8 bit, 32 KB data logger, software and serial interface cable and harness. 999 1840.00 ACR Systems Inc 0          
Data Loggers:Miscellaneous Loggers and Monitors:IAQ IAQ-102 System 01-0328 CO2 monitor with temperature, RH and CO2 8 bit, 32 KB data logger, software and USB Interface cable and harness. 999 1850.00 ACR Systems Inc 0          
 
 
There is six products under Two ( 3 level) sub Catgories.
The Import ignores the third level and all six products are under
 
Data Loggers
    Miscellaneous Loggers and Monitors
 
 
 
 
 
 
Thanks,
 
3/26/2010 9:53:12 AM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Bulk Import Problem on V4
Dear Viewers, please refer to this Link for Summary of Errors:
 
 
Thanks,
Page 2 of 2 (19 posts) << First < Prev 1 2 Next > Last >>