I have came across a problem with uploading via CSV, I sell guitars which all have to have colour options. I have well over 3,000 products to import via CSV but do not have the time to manually edit each product feature. I would much rather edit the CSV spreadsheet!
I thought there would be a CSV option field for this. Is this a feature that will be available in version 1.3.4?
If not I would quite happily pay for this to be modified.
Is this possible? If so then how do I go about approaching the right people?
[quote name=‘guitargeek’]I have came across a problem with uploading via CSV, I sell guitars which all have to have colour options. I have well over 3,000 products to import via CSV but do not have the time to manually edit each product feature. I would much rather edit the CSV spreadsheet!
I thought there would be a CSV option field for this. Is this a feature that will be available in version 1.3.4?
If not I would quite happily pay for this to be modified.
Is this possible? If so then how do I go about approaching the right people?[/QUOTE]I was just looking at the csv output of my shopping cart. It looks like it doesn’t has the ability to export or import product options. Now I’m interested. I openned up tools.php where the actual import/export happens. First thing I noticed is that MySQL is not being used to generate the CSV file, they are brute forcing it. Also, they are not looking at the product_options* tables. So, you will not be able to import options as well with CS-Cart as it is now. But, there are other tools for importing. I use navicat for my database admin. It would be easy using this tool. I would just get the free 30 day trial and import your spreadsheet. You will need to match your item options in your spread sheet the product_options* schema.
[url]http://www.navicat.com/download.html[/url]
You are a star! will get on it asap and post back result. Many thanks
Danny
In the end i asked the cscart team to make a modification by adding another catalog import field called product_option, in my csv spreadsheet i then put the option type and varient using a delimiter. cool! only cost $100 although it would have been nice to have seen in 1.34
Since the base version of CS-Cart has support for product options, it seems to me that the catalog import routines should properly manage those options as well.
Bob