Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Product Features In Individual Columns Rate Topic   - - - - -

 

Posted 17 December 2015 - 11:07 AM #1

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.



 
  • CS-Cart team
  • CS-Cart support team
  • Moderators
  • Join Date: 04-Apr 11
  • 3799 posts

Posted 17 December 2015 - 01:02 PM #2

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.


Sincerely yours, CS-Cart Support Team

 

User guide       |  Developer documentation  |  Core API documentation


 
  • galtinbaeva
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 06-Dec 13
  • 3302 posts

Posted 17 December 2015 - 02:11 PM #3

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.


Simtech Development | sales@simtechdev.com | www.simtechdev.com
CERTIFIED CS-CART PARTNER | LICENSES | DEVELOPMENT | ADD-ONS | DESIGN | UPGRADE

Google Analytics Enhanced Ecommerce - get advanced ecommerce analytics


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 19036 posts

Posted 17 December 2015 - 03:30 PM #4

We are also at your service!


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 
  • Takestock
  • Senior Member
  • Members
  • Join Date: 08-Nov 13
  • 482 posts

Posted 17 December 2015 - 08:01 PM #5

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.

 

Hope this helps.



 
  • galtinbaeva
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 06-Dec 13
  • 3302 posts

Posted 18 December 2015 - 07:53 AM #6

Different products can have several set of features applied. Your solution can work only if all products have the same features.


Simtech Development | sales@simtechdev.com | www.simtechdev.com
CERTIFIED CS-CART PARTNER | LICENSES | DEVELOPMENT | ADD-ONS | DESIGN | UPGRADE

Google Analytics Enhanced Ecommerce - get advanced ecommerce analytics


 
  • Takestock
  • Senior Member
  • Members
  • Join Date: 08-Nov 13
  • 482 posts

Posted 18 December 2015 - 08:20 AM #7

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.

 

 

Alan



 
  • galtinbaeva
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 06-Dec 13
  • 3302 posts

Posted 18 December 2015 - 09:14 AM #8

Thank you for this infromation


Simtech Development | sales@simtechdev.com | www.simtechdev.com
CERTIFIED CS-CART PARTNER | LICENSES | DEVELOPMENT | ADD-ONS | DESIGN | UPGRADE

Google Analytics Enhanced Ecommerce - get advanced ecommerce analytics


 

Posted 18 December 2015 - 10:26 AM #9

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.

 

 

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.

 

To result in the following:

 

Brand: T[Sanderson]; Color: T[Green]; Height: T[10m]; Width: T[50cm]; Repeat: T[25cm]; Match: T[Straight]; EAN Number: T[5012125125515]

 
 
I would appreciate it greatly if you could help me out.
Grant.


 
  • Takestock
  • Senior Member
  • Members
  • Join Date: 08-Nov 13
  • 482 posts

Posted 18 December 2015 - 08:52 PM #10

 

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.

 

To result in the following:

 

Brand: T[Sanderson]; Color: T[Green]; Height: T[10m]; Width: T[50cm]; Repeat: T[25cm]; Match: T[Straight]; EAN Number: T[5012125125515]

 
 
I would appreciate it greatly if you could help me out.
Grant.
 

 

https://www.dropbox....sheet.xlsx?dl=0

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.

https://support.offi...3c-a8ce70609374

The sheet is setup to do 75000 products, Hope your machine can handle it. Save often as excel can crash on low ram.

 

This is rough and ready, hope it helps. PM me if I can help more or you have issues with download and I can email you directly.

 

Alan