The information in this thread might be outdated
If the solution did not help, please, check our Help Portal or contact Ecwid Team.
 
 
Thread Tools Display Modes
  #1  
Old 05-10-2011, 12:15 AM
Michael Lau's Avatar
Michael Lau is offline
Junior Member
 
Join Date: May 2011
Posts: 1
Default

X-Cart Import


Hi,

I'm importing 100 products with options, each product has the same 2 options.

The products imported fine, but only 1 of the 2 options did. Here's an example of the csv.

HTML Code:
[PRODUCT_OPTIONS]
!PRODUCTCODE,!CLASS,!TYPE,!OPTION,!PRICE_MODIFIER,!MODIFIER_TYPE
IMG_3133.jpg,Size,select,7 x 5 inch (unmounted),10,abs
IMG_3133.jpg,Size,select,10 x 8 inch (unmounted),20,abs
Also tried creating an example X-Cart file from within the demo and ended up with:
HTML Code:
[PRODUCT_OPTIONS]
!PRODUCTID,!PRODUCTCODE,!PRODUCT,!CLASSID,!CLASS,!TYPE,!DESCR,!ORDERBY,!AVAIL,!OPTIONID,!OPTION,!PRICE_MODIFIER,!MODIFIER_TYPE,!OPTION_ORDERBY,!OPTION_AVAIL
,IMG_3133.jpg,IMG_3133.jpg,444,Size,Y,Size,1,Y,4125,7 x 5 inch (unmounted),10,$,1,Y
,,,,,,,,,4126,10 x 8 inch (unmounted),20,$,2,Y
which looks basically the same, just with the additional columns which Ecwid doesn't use.

Thanks,

[Sorted so you can delete this!]

Last edited by Michael Lau; 05-10-2011 at 12:58 AM.
  #2  
Old 05-10-2011, 12:56 AM
craig.cooper's Avatar
craig.cooper craig.cooper is offline
Member
 
Join Date: Nov 2009
Posts: 32
Default

Ok, it worked this time. For refrence here's the csv:

HTML Code:
[PRODUCT_OPTIONS]
!PRODUCTID,!PRODUCTCODE,!PRODUCT,!CLASSID,!CLASS,!TYPE,!DESCR,!ORDERBY,!AVAIL,!OPTIONID,!OPTION,!PRICE_MODIFIER,!MODIFIER_TYPE,!OPTION_ORDERBY,!OPTION_AVAIL
,IMG_3133.jpg,IMG_3133.jpg,444,Size,Y,Size,1,Y,4125,7 x 5 inch (unmounted),10,$,1,Y
,,,,,,,,,4126,10 x 8 inch (unmounted),20,$,2,Y
,IMG_3154.jpg,IMG_3154.jpg,444,Size,Y,Size,1,Y,4125,7 x 5 inch (unmounted),10,$,1,Y
,,,,,,,,,4126,10 x 8 inch (unmounted),20,$,2,Y
,IMG_3155.jpg,IMG_3155.jpg,444,Size,Y,Size,1,Y,4125,7 x 5 inch (unmounted),10,$,1,Y
,,,,,,,,,4126,10 x 8 inch (unmounted),20,$,2,Y
,IMG_3184.jpg,IMG_3184.jpg,444,Size,Y,Size,1,Y,4125,7 x 5 inch (unmounted),10,$,1,Y
,,,,,,,,,4126,10 x 8 inch (unmounted),20,$,2,Y

etc......
The Following User Says Thank You to craig.cooper For This Useful Post:
mjc_jr (08-13-2012)
  #3  
Old 05-28-2012, 03:14 PM
Symones Fashion's Avatar
Symones Fashion Symones Fashion is offline
Junior Member
 
Join Date: May 2012
Posts: 6
Default Solved - Importing Product Options in X-Cart Format

After days of trying to figure out how to import product options in a 800+ product catalog in X-CART format I finally got a format to work. This format was mentioned in another post, but it wasn't labeled well enough in order to be found easily. So I thought I would put a "Solved" tag for this particular feature.

I created the file in a simple text editor "Notepad" and then saved it as a "CSV" file.

In order for you to use the format in this post there is one assumption: You have already populated your catalog with the other basic information - Product Name, Sku, Description, etc.

This post is only for those who need to add "Product Options" to many products.

Below is the format that was used for two of my products:

[PRODUCT_OPTIONS]
!PRODUCTCODE,!CLASS,!TYPE,!AVAIL,!PRICE_MODIFIER,! MODIFIER_TYPE,!OPTION_AVAIL,!OPTION
FOGL1014,Size,Y,Y,0.00,$,Y,Medium
,,,,0.00,$,Y,Large
,,,,0.00,$,Y,X-Large
,,,,0.00,$,Y,2X-Large

1008,Size,Y,Y,0.00,$,Y,Medium
,,,,0.00,$,Y,Large
,,,,0.00,$,Y,X-Large


Some important tips: (1) Each new option (large, x-large, etc.) must be on it's own separate line and the 4 commas must be included before each new option line. (2) Each new product (sku) needs to separated by at least one line. (3) This format makes each product option a dropdown list. You can manually change the option to a radio button inside of the product.

Hopefully this saves others time when trying to create their product catalog.

Last edited by Brian Thomas2; 05-28-2012 at 03:17 PM.
The Following 7 Users Say Thank You to Symones Fashion For This Useful Post:
aossa (04-12-2017), Eugene Rimmer (05-28-2012), Euromarque (10-13-2014), KnottixelCreations (05-09-2016), mjc_jr (08-13-2012), StadiumArt.com (08-10-2012), shopbabybunny (06-02-2012)
  #4  
Old 07-23-2012, 02:52 PM
david constable's Avatar
david constable david constable is offline
 
Join Date: May 2012
Posts: 22
Default ecwid - import product options (using xcart method)

I have just spent the last 4 hours trying to figure out exactly how to import a product - with product options - and I have not made any progress - is there an example file I can use ?

The error I get says
"X-Cart import uses only three data blocks from *.csv file - [CATEGORIES], [PRODUCTS] and [PRODUCT_OPTIONS]. Your import file doesn't contain data in any of these blocks."

My csv xcart file looks like this :- can anyone see what is wrong with it ?


[PRODUCTS]
!PRODUCTCODE !PRODUCT
candlex candlex

[PRODUCT_OPTIONS]
!PRODUCTCODE !PRODUCT !CLASS !TYPE !OPTION !PRICE_MODIFIER
candlex candlex colour Y Navy IV 0
Navy II
Navy I
Nasturtium
Mustard Yellow
Mouse Grey
Mink
Moss Green
Midnight Blue
Meadow Green
Marron Glace

Last edited by david constable; 07-23-2012 at 02:54 PM. Reason: more info
  #5  
Old 07-23-2012, 03:55 PM
Eugene Rimmer's Avatar
Eugene Rimmer Eugene Rimmer is offline
Senior Member
 
Join Date: Jan 2011
Location: Ecwid headquarters
Posts: 7,765
Default

Quote:
Originally Posted by david constable View Post
I have just spent the last 4 hours trying to figure out exactly how to import a product - with product options - and I have not made any progress - is there an example file I can use ?

The error I get says
"X-Cart import uses only three data blocks from *.csv file - [CATEGORIES], [PRODUCTS] and [PRODUCT_OPTIONS]. Your import file doesn't contain data in any of these blocks."

My csv xcart file looks like this :- can anyone see what is wrong with it ?


[PRODUCTS]
!PRODUCTCODE !PRODUCT
candlex candlex

[PRODUCT_OPTIONS]
!PRODUCTCODE !PRODUCT !CLASS !TYPE !OPTION !PRICE_MODIFIER
candlex candlex colour Y Navy IV 0
Navy II
Navy I
Nasturtium
Mustard Yellow
Mouse Grey
Mink
Moss Green
Midnight Blue
Meadow Green
Marron Glace
Please, refer to the above post: http://www.ecwid.com/forums/showthre...7813#post27813
  #6  
Old 07-23-2012, 05:02 PM
david constable's Avatar
david constable david constable is offline
 
Join Date: May 2012
Posts: 22
Default

Ok so I took the example , I manually added a product called xxx, sku xxx etc

I then imported this :- (using ; as my delimiter)

[PRODUCT_OPTIONS];;;;;;;
!PRODUCTCODE;!CLASS;!TYPE;!AVAIL;!PRICE_MODIFIER;! MODIFIER_TYPE;!OPTION_AVAIL;!OPTION
xxx;Size;Y;Y;0;$;Y;Medium
;;;;0;$;Y;Large
;;;;0;$;Y;X-Large
;;;;0;$;Y;2X-Large

and I get this error :-
X-Cart import uses only three data blocks from *.csv file - [CATEGORIES], [PRODUCTS] and [PRODUCT_OPTIONS]. Your import file doesn't contain data in any of these blocks.

so why does that happen then ? - this should work -
I havent changed anything other than the sku.
  #7  
Old 07-23-2012, 05:40 PM
Daves Miniature Birds's Avatar
Daves Miniature Birds Daves Miniature Birds is offline
Junior Member
 
Join Date: Apr 2012
Posts: 25
Default

Dave:

Remove the semicolons from "[PRODUCT_OPTIONS];;;;;;;"

It worked like a charm when I imported the file.
  #8  
Old 07-23-2012, 05:48 PM
david constable's Avatar
david constable david constable is offline
 
Join Date: May 2012
Posts: 22
Default

Thanks for that

ok it now worked I removed the commas from the Product options block and it worked fine. For anyone reading this - those extra commas were put in there when I edited the file in Excel and then SavedAs a CSV file type

Last edited by david constable; 07-23-2012 at 05:52 PM.
  #9  
Old 07-23-2012, 05:57 PM
Daves Miniature Birds's Avatar
Daves Miniature Birds Daves Miniature Birds is offline
Junior Member
 
Join Date: Apr 2012
Posts: 25
Default

Glad it's working now. And yes the key is to use NOTEPAD instead of Excel. Excel seems to through in extra delimiters.
The Following 2 Users Say Thank You to Daves Miniature Birds For This Useful Post:
david constable (07-23-2012), KnottixelCreations (05-09-2016)
  #10  
Old 08-10-2012, 02:00 AM
StadiumArt.com's Avatar
StadiumArt.com StadiumArt.com is offline
 
Join Date: Jun 2011
Posts: 3
Default

Here is something else to help you solve your multiple options. In my example, I need different size photo prints with each being a different price. Also, I need another options for mat color(s) if a matted print is chosen and an extra charge for double mats. I also decided to address other sizes and custom mat colors with "contact me" selection so as not to overly clutter the drop down menus. Finally, added another option for engraved title plate.

You can see the end result:
http://stadiumart.com/?page_id=595#e...oduct=13826358
Notice the "Other Sizes", "Mat Colors", and "Engraved Plate" options.

Here is the Product Options set-up I used. (Must have products already in your store as this just adds the options to existing listings.) !ORDERBY is included to specify your preferred order so for eg. shirts can be S, M, L, XL, 2X, etc...

[PRODUCT_OPTIONS]
!PRODUCTCODE,!CLASS,!TYPE,!OPTION,!PRICE_MODIFIER, !MODIFIER_TYPE,!ORDERBY
Aug11a-13x19-p,Other Sizes,Y,11x14 Photo Print,-5,$,1
,,,11x14 Mat w/8x10 Photo,-5,$,2
,,,16x24 Photo Print,+15,$,3
,,,24x36 Photo Print,+55,$,4
,,,Contact for other sizes & options,0,$,5
Aug11a-13x19-p,Mat Colors,Y,Print Only - No Mat,0,$,1
,,,Forest Green,0,$,2
,,,White,0,$,3
,,,Cream,0,$,4
,,,Dark Gray,0,$,5
,,,White / Green,+5,$,6
,,,Cream / Green,+5,$,7
,,,Green / Gold,+5,$,8
,,,Custom Mat - Email Us,0,$,9
Aug11a-13x19-p,Engraved Plate,Y,None Needed,0,$,1
,,,Gold Tone Plate,+5,$,2

Aug12a-13x19p,Other Sizes,Y,11x14 Photo Print,-5,$,1
,,,11x14 Mat w/8x10 Photo,-5,$,2
,,,16x24 Photo Print,+15,$,3
,,,24x36 Photo Print,+55,$,4
,,,Contact for other sizes & options,0,$,5
Aug12a-13x19p,Mat Colors,Y,Print Only - No Mat,0,$,1
,,,Forest Green,0,$,2
,,,White,0,$,3
,,,Cream,0,$,4
,,,Dark Gray,0,$,5
,,,White / Green,+5,$,6
,,,Cream / Green,+5,$,7
,,,Green / Gold,+5,$,8
,,,Custom Mat - Email Us,0,$,9
Aug12a-13x19p,Engraved Plate,Y,None Needed,0,$,1
,,,Gold Tone Plate,+5,$,2
The Following 5 Users Say Thank You to StadiumArt.com For This Useful Post:
aossa (04-12-2017), deon vd sandt (05-17-2016), Jasmine Little (06-15-2016), justatraceco (12-09-2015), sabs Store (06-08-2013)
 
The information in this thread might be outdated
If the solution did not help, please, check our Help Portal or contact Ecwid Team.

Tags
!class, !type, import, product options, xcart

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:50 AM.
Powered by vBulletin® Version 3.8.11. Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.