Product !CLASS working, but !TYPE not updating corectly

mjc_jr · #11 08-27-2012, 07:12 AM

I have been trying to get this to work for days. The system says it updated but only the !Class gets added. The input type gets set to text field instead of drop-down list, so the individual options don't take. Check my code and see that !TYPE is y, which is supposed to indicate drop-down list.

Code:

[PRODUCT_OPTIONS]
!PRODUCTCODE,!CLASS,!TYPE,!OPTION,!PRICE_MODIFIER,!MODIFIER_TYPE,!ORDERBY
6529 M,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7
,,,CUSTOM,0,$,8

6529 A,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XL,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7
,,,CUSTOM,0,$,8

6536 M,Color,y,Army ACU Digital,0,$,1
,,,Marine Desert Digital,0,$,2

7020,Color,y,Army ACU Digital,0,$,1
,,,Marine Desert Digital,0,$,2

7021A,Size,y,S/M,0,$,1
,,,L/XL,0,$,2
,,,2X/3X,0,$,3

7021M,Size,y,S/M,0,$,1
,,,L/XL,0,$,2
,,,2X/3X,0,$,3

7026A,Size,y,MEDIUM,0,$,1
,,,LARGE,0,$,2
,,,XL,0,$,3
,,,2XL,0,$,4

7026M,Size,y,MEDIUM,0,$,1
,,,LARGE,0,$,2
,,,XL,0,$,3
,,,2XL,0,$,4

7027,Size,y,MEDIUM,0,$,1
,,,LARGE,0,$,2
,,,XL,0,$,3
,,,2XL,0,$,4
7027,Color,y,Army ACU Digital,0,$,1
,,,Marine Desert Digital,0,$,2

7032,Size,y,MEDIUM,0,$,1
,,,LARGE,0,$,2
,,,XL,0,$,3
,,,2XL,0,$,4
7032,Color,y,Army ACU Digital,0,$,1
,,,Marine Desert Digital,0,$,2
7032,Sleeves,y,M/L 23.5-25.75 inches,0,$,1
,,,XL/2XL 25.375-27.75 inches,0,$,2

4531,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XL,0,$,5
,,,2XL,0,$,6
4531,Color,y,Blue,0,$,1
,,,Silver,0,$,2
,,,Black,0,$,3

6625,Size,y,M/L (100-175 lbs),0,$,1
,,,L/XL (175-250 lbs),0,$,2
,,,2XL (250-300 lbs),0,$,3

6626bl,Size,y,M/L (100-175 lbs),0,$,1
,,,L/XL (175-250 lbs),0,$,2
,,,2XL (250-300 lbs),0,$,3

6626bk,Size,y,M/L (100-175 lbs),0,$,1
,,,L/XL (175-250 lbs),0,$,2
,,,2XL (250-300 lbs),0,$,3

6626kh,Size,y,M/L (100-175 lbs),0,$,1
,,,L/XL (175-250 lbs),0,$,2
,,,2XL (250-300 lbs),0,$,3

6626-HV,Size,y,M/L (100-175 lbs),0,$,1
,,,L/XL (175-250 lbs),0,$,2
,,,2XL (250-300 lbs),0,$,3

6626-I,Size,y,M/L (100-175 lbs),0,$,1
,,,L/XL (175-250 lbs),0,$,2
,,,2XL (250-300 lbs),0,$,3

6626-N,Size,y,M/L (100-175 lbs),0,$,1
,,,L/XL (175-250 lbs),0,$,2
,,,2XL (250-300 lbs),0,$,3

6627,Size,y,M/L (100-175 lbs),0,$,1
,,,L/XL (175-250 lbs),0,$,2
,,,2XL (250-300 lbs),0,$,3

6826,Size,y,M/L (100-175 lbs),0,$,1
,,,L/XL (175-250 lbs),0,$,2
,,,2XL (250-300 lbs),0,$,3

6619,Color,y,Blue,0,$,1
,,,Khaki,0,$,2

6620,Color,y,Blue,0,$,1
,,,Khaki,0,$,2

5538,Size,y,S/M (32-42 inches),0,$,1
,,,L/XL (42-52 inches),0,$,2

6529sv,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7

6529bl,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7

6529bk,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7

6529hl,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7

6529kk,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7

6529pk,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7

6529 C,Size,y,5-6 yrs,0,$,1
,,,7-9 yrs,0,$,2
,,,10-12 yrs,0,$,3

6529 A,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7

6529 M,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7

6530bk,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7

6530bl,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7

6530hl,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7

6530sv,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7

6530 Fbk,Size,y,SMALL,0,$,1
,,,MEDIUM,0,$,2
,,,LARGE,0,$,3
,,,XLARGE,0,$,4
,,,2XL,0,$,5

6530 Fbl,Size,y,SMALL,0,$,1
,,,MEDIUM,0,$,2
,,,LARGE,0,$,3
,,,XLARGE,0,$,4
,,,2XL,0,$,5

6530 Fkk,Size,y,SMALL,0,$,1
,,,MEDIUM,0,$,2
,,,LARGE,0,$,3
,,,XLARGE,0,$,4
,,,2XL,0,$,5

6530 Fsv,Size,y,SMALL,0,$,1
,,,MEDIUM,0,$,2
,,,LARGE,0,$,3
,,,XLARGE,0,$,4
,,,2XL,0,$,5

6531bk,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7

6531bl,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7

6531hl,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7

6531sv,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7

6532,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7
6532,Color,y,Silver,0,$,1
,,,Blue,0,$,2
,,,Black,0,$,3
,,,Hi-Viz-Lime,0,$,4

6533,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
6533,Color,y,Silver,0,$,1
,,,Blue,0,$,2
,,,Black,0,$,3
,,,Hi-Viz-Lime,0,$,4

6537bw,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7

6537sw,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7

6538o,Size,y,S/M,0,$,1
,,,L/XL,0,$,2
,,,2X/3X,0,$,3

6538hl,Size,y,S/M,0,$,1
,,,L/XL,0,$,2
,,,2X/3X,0,$,3

6539bsb,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7

6539sb,Size,y,XSMALL,0,$,1
,,,SMALL,0,$,2
,,,MEDIUM,0,$,3
,,,LARGE,0,$,4
,,,XLARGE,0,$,5
,,,2XL,0,$,6
,,,3XL,0,$,7

6517,Size,y,S/M,0,$,1
,,,L/XL,0,$,2
6517,Color,y,Blue,0,$,1
,,,Silver,0,$,2
,,,Black,0,$,3

6519,Color,y,Blue,0,$,1
,,,Khaki,0,$,2
,,,Black,0,$,3

6519 M,Color,y,Army ACU Digital,0,$,1
,,,Marine Desert Digital,0,$,2

6573,Color,y,Blue,0,$,1
,,,Black,0,$,2

6591,Size,y,S/M,0,$,1
,,,L/XL,0,$,2
,,,2XL/3XL,0,$,3

mjc_jr · #12 08-27-2012, 07:24 AM

SOLVED! Well, apparently you have to put a "Y" instead of a "y" in the !TYPE or it won't work.

Holly and Martin Advertising · #13 09-21-2012, 06:24 PM

In follow up to this thread, do you know how to set the option to be required if the option is a custom text field? The setting is visible in the API, but I cannot import with the option details using X-Cart import - I tried a few things, including the below.

Thanks for any help!

[PRODUCT_OPTIONS]
!PRODUCTCODE,!PRODUCT,!CLASS,!TYPE,!OPTION,!REQUIR ED,!PRICE_MODIFIER,!MODIFIER_TYPE
37-128-033-1-23,Buy Now Button - 24 Cans of FireGlo Gel Fuel,Your Website (ex: Website.com),TEXTFIELD,TRUE,TRUE,0,Absolute
37-128-033-1-23,Buy Now Button - 24 Cans of FireGlo Gel Fuel,Link URL (ex: website.com/products/289030924),TEXTFIELD,TRUE,TRUE,0,Absolute

Kess · #14 09-24-2012, 01:54 PM

Please refer to our reply in http://www.ecwid.com/forums/showthre...hybrid&t=14484