cannot create session when trying to update database

[gjh42]

I have seen people recommend using easy populate to export the info from the old store, massage as desired, and import into the new one.

[brad_at_foreverybody]

I have seen people recommend using easy populate to export the info from the old store, massage as desired, and import into the new one.

excellent info, thanks. Do you know if that can import from an older version to a newer one? I will look into this.

Edit: looked into EP and it lists 1.3.8 for compatibility...

[DrByte]

As for EP, it only handles products and categories. Not attributes or customers/orders.

[brad_at_foreverybody]

Thanks for the advice Dr. Byte.

I'm 99.9% confident that I have successfully imported products/categories/coupons form the old database correctly. I actually am a webdeveloper with many years of php and mysql experience. I just wanted to use officially supported means of migrating data if possible.

I am now debating about orders. See I didnt import disabled products (discontinued products number in the 1000s for this store) but obviously there were past orders for said products. I dont think I really need the old orders as the orders are automatically being pushed into our ERP system by some custom code I wrote. Since the orders are in that system we also run our reports form that system so the only side effect i can think of are customers not being able to look up order history from the old orders.

if i did choose to import orders would it be benign to have order products that do not exist in the products table? (i did import the products_id from the old store so they have the same id in the old and new database)

if i didnt bring orders in I am assuming setting the auto increment for the orders_id column on the orders table to that of the old store would be sufficient to have the new orders start incrementing from where they left off. is that a safe assumption?

again sorry for breaking the rules. I assure you a donation is in your future (even if you cant help me here, zencart is great stuff, kudos)

[gjh42]

I can't answer about the discontinued products, but you can set the order id to pick up where the old store left off. You don't do that in the db, but in admin > Tools > Store Manager > Reset Current Order ID.

[brad_at_foreverybody]

I can't answer about the discontinued products, but you can set the order id to pick up where the old store left off. You don't do that in the db, but in admin > Tools > Store Manager > Reset Current Order ID.

Thanks! I'll do that instead of using a sql command in phpmyadmin.