I have over 70,000 products to upload and each of them have between 3-5 features. I.e (size, color, weight, material, etc.)
As you can imagine, doing this is very tedious. Is there an add on or a way to allow me to upload the CSV file as having individual columns for features ? This way will save a lot of hours.
For example - instead of having Size: T[50cm x 20cm]; Color: T[Green]; Weight: T[5kg]; Material: T[Steel]
I could have an individual column for size, color, weight, material and any other feature that I may need.
I have over 70,000 products to upload and each of them have between 3-5 features. I.e (size, color, weight, material, etc.)
As you can imagine, doing this is very tedious. Is there an add on or a way to allow me to upload the CSV file as having individual columns for features ? This way will save a lot of hours.
For example - instead of having Size: T[50cm x 20cm]; Color: T[Green]; Weight: T[5kg]; Material: T[Steel]
I could have an individual column for size, color, weight, material and any other feature that I may need.
Thanks.
Unfortunately, there is no such feature in the default version of CS-Cart.
Unfortunately, code modification is required: move features to separated columns and export/import them in this way. You can contact us in our HelpDesk, so that we can help you.
I have over 70,000 products to upload and each of them have between 3-5 features. I.e (size, color, weight, material, etc.)
As you can imagine, doing this is very tedious. Is there an add on or a way to allow me to upload the CSV file as having individual columns for features ? This way will save a lot of hours.
For example - instead of having Size: T[50cm x 20cm]; Color: T[Green]; Weight: T[5kg]; Material: T[Steel]
I could have an individual column for size, color, weight, material and any other feature that I may need.
Thanks.
Depending on how you have your data, ie CSV etc. You could put you data in different cells in excel and use a formula to add the contents together into a single sell. in excel in cell A1 the formula =B1&C1&D1 if you put 1 2 3 into the respective cell you will get a result of 123 in A1.
You can also use this method to add the special characters to build you final result to upload. Then just cut the results as text to whatever sheet you need put it to.
I used this to convert a 300000 product database exported to CSV from lemonstand shopping cart to CS Cart. It took me two days to write the formulas in excel as the data fields were all completely different. But the conversion took less than 2 minutes.
Different products can have several set of features applied. Your solution can work only if all products have the same features.
Simtech
Excel i very powerful in the correct hands, if I have
in cell A1 the formula =B1&C1&D1&E1&F1 if you put 1, 2, 3, 4, 5 into the respective cell you will get a result of 12345 in A1.
in Cell A1 the formula =B2&C2&D2&E2&F2 if I put 1,2, blank, }, 5 in the respective cells I would get 12}5 as the result.
So write a single line of maybe one but possibly many related formulas, select them and hold the CTRL Key when dragging down will make the formulas do what you need.
I like to break my formulas up across a few cells,
formulas can be written to ignore blanks, leave spaces, anything you can imagine to do.
So you can build a single sell of information out of many cells made up of many more cells. All you have to do is apply logic from the result you want back to how you want the user to input the information.
The user input could easily be controlled using a data form, with the product code as the control.
Another formula could be used to insert the results into the correct field in the CSV file from CS Cart export. matching the product code to ensure the correct entries are added to the correct product.
The don't have to be even in the same order in the different tables in excel.
Excel i very powerful in the correct hands, if I have
in cell A1 the formula =B1&C1&D1&E1&F1 if you put 1, 2, 3, 4, 5 into the respective cell you will get a result of 12345 in A1.
in Cell A1 the formula =B2&C2&D2&E2&F2 if I put 1,2, blank, }, 5 in the respective cells I would get 12}5 as the result.
So write a single line of maybe one but possibly many related formulas, select them and hold the CTRL Key when dragging down will make the formulas do what you need.
I like to break my formulas up across a few cells,
formulas can be written to ignore blanks, leave spaces, anything you can imagine to do.
So you can build a single sell of information out of many cells made up of many more cells. All you have to do is apply logic from the result you want back to how you want the user to input the information.
The user input could easily be controlled using a data form, with the product code as the control.
Another formula could be used to insert the results into the correct field in the CSV file from CS Cart export. matching the product code to ensure the correct entries are added to the correct product.
The don't have to be even in the same order in the different tables in excel.
Alan
Thank you for this detailed explanation. How could I get this to work if I wanted something like this:
I have 7 Columns labeled Brand, Color, Height, Width, Repeat, Match & EAN number. I also have 1 column labeled Features.
I will take 1 row as an example:
Brand = Sanderson
Color= Green
Height= 10m
Width= 50cm
Repeat= 25cm
Match= Straight
EAN Number= 5012125125515
In features, I have Brand: T[]; Color: T[]; Height: T[]; Width: T[]; Repeat: T[]; Match: T[]; EAN Number: T[]
and I would like the brackets to then be filled with the information from the 7 other columns.
Here is a link to a Dropbox folder with the excel sheet. Within the excel sheet you will find 3 tables.
Data entry sheet, Formula Sheet, Results Sheet. the two later ones are locked, I will PM the password to anyone that askes by PM.
I have added another field to the sheet, called product code, As I am presuming that some form of relationship needs to be entered to relate to the product.
You will see a lot of blank entry's in the result sheets that will complete as you fill in the data. When finished just cut the completed lines as text into a new sheet.
I am a little bit confused as to weather you are talking about features or options. Regardless of that I will also presume that if a product needs two lines of features then you would just enter the same product code in the product code field.
You may need these instruction to add the data form to excel and on how to use it.