Jump to content

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

Import Product Features Rate Topic   - - - - -

 
  • JackConnick
  • Senior Member
  • Trial users
  • Join Date: 03-Jun 12
  • 293 posts

Posted 06 February 2019 - 05:14 PM #1

I have a 4.5.2 store with some groups of products that I want to add feature data to. I haven't imported data this way before and could use some help.

 

I've defined the feature variants on the products in the store. They are all text.

 

I have an excel workbook with the product name and codes, as well as the feature variant data under the same names. I do not need to add anything else.

 

The docs for this are sort of vague. I've tried exporting a file to use as a guide, but it really doesn't give a clear idea on setting up the import file.

 

I've seen a few add-ons, and I'm not opposed to buying something to help, but I'm not going to pay $257 (SimDev) for something that I won't probably be using all that often.

 

Could someone walk me through the process, post links, or offer some add-ons that will make this easier?

 

TIA,

Jack

 

 

 



 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11248 posts

Posted 06 February 2019 - 07:35 PM #2

You should be able to setup a product with features and then export that product to view what the 'Features' column should look like.


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • JackConnick
  • Senior Member
  • Trial users
  • Join Date: 03-Jun 12
  • 293 posts

Posted 06 February 2019 - 08:44 PM #3

Well, I get all the products and something like this. But I don't see how I'm going to get the .csv file from excel to look like it. Plus I'm not sure what the "M" and "S" feature variant codes are.

 

 

"en";"CB15000P";"Big Blue CB15000P 15000 Lumen Video Light";"2792";"(Google export features) Availability: S[in stock]; Brand: E[Big Blue]; Focus & Video Light Types: M[Video Lights]; Condition: M[New]; Google Category: M[Cameras & Optics > Camera & Optic Accessories > Camera Accessories > Underwater Camera Housings]; Google Priority Label: M[Medium]; (Lights) Lumen Output: M[15,000]; (Lights) Beam Types: M[Flood]; (Lights) Burst Capability: S[No]; (Lights) Depth Rating: M[300']; (Lights) Controls: M[Push-button]"

 

I saw Econ-labs add-on to have the features in columns. It seems like this might help organize them?

https://www.ecom-lab...mns-add-on.html

 

Jack



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

Posted 07 February 2019 - 07:33 AM #4

"C" - Single Check box
"M" - Multiple Check box
"S" - Text Select box
"N" - Number Select box
"E" - Brand/Manufacturer Select box
"T" - Text
"O" - Number
"D" - Date
 
Use our addon to make import easier 

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 руб.


 
  • JackConnick
  • Senior Member
  • Trial users
  • Join Date: 03-Jun 12
  • 293 posts

Posted 07 February 2019 - 04:32 PM #5

Thanks for that and I'll try your add-on. However right now my .csv data file looks like this:

 

 

Big Blue VL15000P PRO MINI TC,15000,Flood / Red,160°,No,180 Minutes,100m / 330 ft,Push button with battery level meter,"3"" x 5"" / 76 x 127.2 mm",310g,769g,Li-ion 18650 x 7,"$1,149.99 ",,VL15000P-Pro-MINI-TC,"Cool white, Warm white",CRI 75,"6500K, 5500K"

 

How do I get all the formatting into it? Will your add-on do that so that these features go into the products?

 

TIA,

Jack



 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11248 posts

Posted 07 February 2019 - 11:06 PM #6

Need to provide the header so we know what comma separated values are applied to what import column.  But I don't see any features defined.  Generally these are "name: value" or "{group name}name: value" type of data.


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


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

Posted 08 February 2019 - 05:51 AM #7

Thanks for that and I'll try your add-on. However right now my .csv data file looks like this:

 

 

How do I get all the formatting into it? Will your add-on do that so that these features go into the products?

 

TIA,

Jack

 

Go to Administration -> Import data -> Products (deprecated) and click on  the (?) icon. You will see instructions for the required format

 

Our addon does not import/export features data in one column. Separate column is created for each product feature


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 руб.