dashCommerce

I have about 1500 products that need to be inserted into my product catalog. I have Excel sheets which have the relevent information. I know there is a way to do a bulk insert. Which tables are required for the products to be displayed? Is there a ORD for Dash 3.0?

 Thanks for any help ahead of time.

-Stephen

Hi Surrealis,

Webpro6030 is using dbCopy to import his access database (see: http://dashcommerce.org/forums/t/864.aspx).  This would definitely a utilitly that I could use as well.

Currently, I accomplish this by importing the spreadsheet into FoxPro table (I used to do most of my programming in FoxPro) and then write small programs to create the SQL Insert commands and then run the insert commands using SQL Server Managment Studio.

Louis

Hey there,

I thought I'd add my two cents worth in here... in my setup I have an overnight batch file that is FTP'd by my wholesaler... (it's a CSV file). I then use the bulk insert sql function to load up a temp table and from there execute a custom stored proc which validates the data, then inserts/updates the appropriate tables in the appropriate order... this occurs nightly...

hope this helps

This is great info - I am running into this issue right now.

I have a few questions about the table structure for products.

For a straight insert, it looks like we need existing ids for manufacturer, status, type, and shipping - other than that do we need to update the attribute table?  Or, is that only if we are using attributes?

Any other table that needs to be updated on a bulk insert?

 Thanks!

Hey there....

Here's the order in which I process my batches into the dashcommerce db.

1. BULK INSERT into a temp table
2. From the temp table I do the following;
    a. Create Manufacturer ( dashCommerce_Store_Manufacturer Table) if not exists already
    b. Create Category ( dashCommerce_Store_Category Table) if not exists already
    c. INSERT into the products table (or update if exists already) - This gets you your productID -
    d. INSERT into the dashCommerce_Store_Product_Category_Map table
    e. INSERT into the SKU Table if sku ( dashCommerce_Store_Sku Table) if doesn't exist already OTHERWISE simply update the new inventory

VOILA!... thats all there is to it....

Hope this helps
da bibber

 Without me having to go and dig them out, what are the tables that have to be updated and if possible in what order? I can tweak my links to make it work.

 I used to do it when I was using the CSK but then things just started changing so fast that i deleted my site and have just came back to it because i like the new look.

If your a-e is the correct or just let me know, otherwise i am going to create a mirro database and see how bad i screw it up!

Thanks

tjatwood

www.hookupstuff.com

There is no upgrade path from dashCommerce 2.X to dashCommerce 3.X because there were quite a few changes. You can try, but no promises

Anybody come up with a nice script to do this yet? I have been able to mass insert 1531 products into the list, but i am having problems with the over 6000 images into the right place?

 Thanks

Tom

 I may sound like a broken record on this subject, but I have a firm belief that there should be a admin UI to import/export bulk items.  This makes or breaks the use of the ecommerce software for many business owners like myself who are not scripters/developers and feel intimidated when it comes to this.  I do not understand why the developers or thrid parties have not made a import UI for this.  Most other ecommerce systems I have reviewed and tried either had this feature in the form of a commercial version or as a add on module from either the Developers or 3rd parties.

  I know that to many who are savy to the lingo this is no problem, but as for me I haven't the luxury or the time to learn to script or code.  I would rather pay someone for a UI add in and focus on sales.

I am currently working on an auto import tool, it is a windows application and i have been testing and it works quite well, i'm not sure how to make this available to the community. I have not decided if i want to build this into the admin screens or not.

Does anyone know if this ever happened?

Im now in this position and could do with a program like this.

 Jon

Not sure about the "import tool" from skobyjay... but I'm hoping to be releasing an simple (web based) "product import" utility/add-on soon.

(am currently waiting to hear back from Chris.. will keep you posted).

Regards
aobi 

Web based "product import" utility/add-on is now availabe from the dashCommerce store