Forums / Setting Up Categories, Products, Attributes / import attributes from one store to another?

import attributes from one store to another?

Views: 1,409

Results 1 to 3 of 3
17 May 2011, 6:28 AM
#1
thomaswhiteeagle avatar

thomaswhiteeagle

New Zenner

Join Date:
May 2007
Posts:
93
Plugin Contributions:
0

import attributes from one store to another?

I'm trying to import the attributes, (option values, option names0 from one zen cart to another without overwriting the existing product attributes of the cart importing to. Both use 1.3.9f.

I export the products_options, products_option_types, products_options_values from the database of the cart I want to copy the options values from.

Under structure, I tick the "add drop table". "add if not exists", "add auto increment value", "enclose table and field name with backquotes" are all checked by default.

under data: complete inserts, extended inserts is checked by default.

I export the file then import it into my other database but invariably it simple overwrites the existing options values. How can I import the options values from one zencart into another without overwriting the existing values without having to manually export them and then insert them?

17 May 2011, 9:18 AM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: import attributes from one store to another?

nvariably it simple overwrites the existing options values. How can I import the options values from one zencart into another
Essentially you can not because each is incremented with a value and those values will clash as they will have already been used

Zen-Venom Get Bitten

18 May 2011, 1:04 AM
#3
thomaswhiteeagle avatar

thomaswhiteeagle

New Zenner

Join Date:
May 2007
Posts:
93
Plugin Contributions:
0

Re: import attributes from one store to another?

uh huh.. sucks it does.. Well then, I suppose I could wade through the import to database, figure out the last value of each particular section then change the values of the import from database sections sql file to increment from that point thereof. Then it simply becomes a question of if that would be faster than building them all from scratch.