Zen Cart Logo
Forums / Setting Up Categories, Products, Attributes / I have 1100 option values to import, how to do it in batch?

I have 1100 option values to import, how to do it in batch?

Views: 1,162

Results 1 to 8 of 8
28 Dec 2011, 3:18 AM
#1
mybiz9999 avatar

mybiz9999

Zen Follower

Join Date:
Jul 2010
Posts:
143
Plugin Contributions:
0

I have 1100 option values to import, how to do it in batch?

Hi,I have 1100 option values to import, how to do it in batch?

the 1100 option values are for a single option (style of clothes).

No luck with Easypopulate or apsona.
Can I do it with the Sql?

Please help. Thank you!

28 Dec 2011, 4:02 AM
#2
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,668
Plugin Contributions:
0

Re: I have 1100 option values to import, how to do it in batch?

You're kidding - you expect your customers to choose from a list of 1100 options?

Please do not PM for support issues: a private solution doesn't benefit the community.

Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

28 Dec 2011, 4:56 AM
#4
mybiz9999 avatar

mybiz9999

Zen Follower

Join Date:
Jul 2010
Posts:
143
Plugin Contributions:
0

Re: I have 1100 option values to import, how to do it in batch?

5000 products, 1100 option values.

each product has 4 or 5 option values.

anything wrong?

Kim:

You're kidding - you expect your customers to choose from a list of 1100 options?

28 Dec 2011, 4:58 AM
#5
mybiz9999 avatar

mybiz9999

Zen Follower

Join Date:
Jul 2010
Posts:
143
Plugin Contributions:
0

Re: I have 1100 option values to import, how to do it in batch?

thank you.
yes,that's right. firstly, what I need to do is import all option values.

any ideas ?

gjh42:

Or do you perhaps use only a subset of those option values for any given product?

28 Dec 2011, 9:43 AM
#6
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: I have 1100 option values to import, how to do it in batch?

We had a similar issue, needing to load about 1500 option values. We used Apsona... but one has to get the initial csv file right. This took a bit of time.

Follow Apsona tutorial on attribute loading.

20 years a Zencart User

5 Jan 2012, 2:22 AM
#7
mybiz9999 avatar

mybiz9999

Zen Follower

Join Date:
Jul 2010
Posts:
143
Plugin Contributions:
0

Re: I have 1100 option values to import, how to do it in batch?

anyone can offer any help?

27 Aug 2012, 11:50 PM
#8
mybiz9999 avatar

mybiz9999

Zen Follower

Join Date:
Jul 2010
Posts:
143
Plugin Contributions:
0

Re: I have 1100 option values to import, how to do it in batch?

I have got the method to add option value quickly.

"INSERT INTO dac_zc01.products_options_values (products_options_values_id,
language_id ,
products_options_values_name ,
products_options_values_sort_order
)
VALUES ('164','1', 'R5-5C_YellowishLight_OrangePeel_1-7ModeCircuit', '67')" "INSERT INTO dac_zc01.products_options_values_to_products_options (
products_options_values_to_products_options_id ,
products_options_id ,
products_options_values_id
)
VALUES (
'190', '20', '164')"