Multiply Options & Data Port Uploads

[dwawrzyn]

Has anyone tried to upload using the data port with product that has multiple options? What we would like to do is upload product that has size options and different prices for each options.

Dave

[Naveed]

If you are talking about the CSV upload then this feature has its limitations. You can not define and upload product options using CSV upload. However you can define basic product information. The intent of CSV download/upload is to provide batch editing functionality. To create product options you have to use the web interface to define those manually.

[AbleMods]

There are other ways to import your data without using the data client or the site admin pages.

Since all the data is SQL-based, someone fluent in SQL could load the data into the tables. Someone fluent in .Net programming can write their own import routines that not only bring in the product records but build all the options and variants as well.

The difficulty in accomplishing this is based on how your source data is organized and how you want the options/variants built in AC7.

I wrote all my own programming to bring in about 10,000 products with an additional 8,000+ options/variants. Working with variants in code isn't easy but it is possible. Everything you see in my store was brought in through programming - nothing is hand-entered. It also is updated electronically, so there are no manual stock adjustments.

[beveled]

Would you mind sharing some of the SQL that you used to import your products? I exported my ac_products table as a formatting guide and then imported a bunch of products with that same format, but they are still not showing up. My guess is that I need to populate other tables as well, such as the categories table.

Could you tell me what tables need to be updated?

Thanks,

Sheldon

[beveled]

I found it . . . needed to update the catalognodes table. This was helpful: http://wiki.ablecommerce.com/index.php/ ... Categories

It was the CatalogNodes table that needed updated for my new products.

Sheldon

[AbleMods]

Yes ac_CatalogNodes must be populated as well. Remember that I wrote my imports in .Net VB code, so there was no need (or desire) to write SQL commands.

[bemara579]

Can you share the VB.NET code?

I was thinking of building one myself, but would love to build off yours. Hopefully eventually getting it into the core code of AbleCommerce's DataPort.