an ASP.NET Open Source CMS & eCommerce platform
Skip Navigation LinksHome > DotShoppingCart Forums > Development > Suggestions and Feedback > Incremental Bulk Import Mode
Last Post 3/3/2011 10:27:55 AM By Bahram. 2 replies.
3/18/2010 4:19:05 PM
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Incremental Bulk Import Mode
 Hi Luke,
The nature of the Ecommerce and the incremental updates to the store requires Bulk Import to have an Add-only mode. That means It should not  touches old data, but adds data to existing one, in ternms of category, subcat , SKU and Images.
Some of the images are added manually to the store and may not be avialable on batch file
Example :
We have a current Category - subCat - SKU model that is uploaded and working from V3 and V3.1
After migration to V4 we may need to add a new Category- Subcat with some of the existing SKUs repeatedly. 
3/2/2011 11:15:10 AM
Posts: 21
Joined: 12/18/2007
Re: Incremental Bulk Import Mode
Hi Bahram, I am sorry but I have to disagree with your suggestion.
If DSC begins to have more options on importing data, it will have endless options of importing data. I think it should remain as simple as it is now.
Instead of creating more options, I think its better DSC to modify <Export> function.
Assuming that Excel is most common spread sheet everyone is using, importing data should have same columns and formats exporting data.  Currently, it is different.
I think it will be much easier if we can simply export current data and open it in Excel and add or subtract information and Bulk Import newly updated Excel file.
In this way, product informations that have been modified in Admin will not be lost also.
3/3/2011 10:27:55 AM
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: Incremental Bulk Import Mode
 Hi Travis,
Well my post dates back to 2008 and I do not remember the details. but your reply is based on Export which is totally dfferent function and Excel which is a widely used Horizontal software comparing to our Vertical Ecommerce.
Le me give you an example : We currntly have 200 products under 8 main categories and each have some other subcategories.
The system is up from 2008 and in 2011 we decide to build up a new category grouping based on Industry for our products.
Now we have 8 to 10 Industry and Segments (SubIndustry) and we need to do the bulk Import so we make the Import excel Sheet for all products under Industry-Segments,
but the products are already in the Store Databse. so Bulk import SP should create new Category-Product relationships but not new Product table entries.
That implies the incremental nature of Import.