Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Importing Customers from old store PROBLEMS!!


kona72

Recommended Posts

Posted

Hi All,

 

Building a new store with a fresh install and i wanted to import the customer table form the old DB. I exported as a CSV and everything exported just fine. The importing worked great as well...

 

Problem occurred when i went to the customers in the admin panel.... I get this error now....

 

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /home/.sites/28/site1/web/catalog/admin/customers.php on line 733

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/.sites/28/site1/web/catalog/admin/customers.php on line 733

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/.sites/28/site1/web/catalog/admin/customers.php on line 735

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/.sites/28/site1/web/catalog/admin/includes/classes/object_info.php on line 17

Warning: Variable passed to each() is not an array or object in /home/.sites/28/site1/web/catalog/admin/includes/classes/object_info.php on line 18

 

Can anyone help with this??

 

Thanks in advance!!!

Posted

Curtis,

Try and isolate the problem...load maybe only 1 or two records and see if the problem still exist...let us know...

I hope this helps

dittone.com

Roman

Posted

I just did this. I might be of some help. You need information from 3 tables.

 

1. customers 2. customers_info 3. address_book

 

Now you may still have your errors because some numbers don't match up. Correct me if I'm wrong.

 

1. customers

 

columns: customers_id, customers_default_address_id

 

2. customers_info

 

columns: customers_info_id

 

3. address_book

 

columns: address_book_id, customers_id

 

All of the numbers in the above columns need to match up.

 

There are exceptions when a customer has more than one address defined. If your customer has more than one address they will have a couple of address_book_id numbers with the same customers_id. This will make your address_book table a little more complicated.

Other great Open Source (Free) programs: (Free as in free speech not free beer)

The Gimp - An image program. | Firefox - All you have to do is add the Web Developer add-on to make this web browser complete. | FileZilla - An ftp program. | Inkscape - A good program to create images with. | Thunderbird - An email program. | Openoffice.org - An office suite that is compatible with MS Office. | Abiword - Another office suite. | Audacity - A sound recording tool. | ddp's Picks | Wordpress - An easy to use blogging software. | Joomla - An easy to use CMS that has ecommerce plug-ins. | Drupal - Another CMS

How do I find these programs? Google Search!

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...