Categories
View Replies (3)

Resolved Import users orders

  1. DarkoF
    DarkoF
  2. RO CSVI
  3. Tuesday, 11 April 2023
  4.  Subscribe via email
Hi,
As we already discus in one ticket before I would like Import users and orders so they could chek their past orders.

I import Joomla users successfully It seems there
is 74 Joomla users registered - I import them and I can check they are correctly registered as Joomla users

All others buyers I get when I export orders was more than 300 this it seems are not registered buyers _ I import this file of Orders too

headers of file orders for Import which I import are:
email,virtuemart_order_id,order_number,user_currency,payment_element,order_total,order_subtotal,order_tax,order_status_name,order_status


Then I import also Orders Items, - Some of SKUs was not correct, but wast mayority are
Header of file: Order Items
virtuemart_order_id,product_sku,order_status_name,product_quantity,order_item_name,product_item_price,product_final_price

So result was

When I import orders I get 98 incorrect - Incorrect Failure Cannot process user, no user ID found, So did I need some more header with Id at Orders, as I said some users are not registered and they buy anonymously.

I can see imported Joomla users as Shoppers back in Virtue mart, but there are no others listed, they all have orders 0 at orders tab. Something missing here.

Thank you
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
In your User info export template on Options tab set Shopper group name filter to All shopper groups and No assigned shoppergroups, save the template and run the export and check.

If you still have problem post the export debug log to check. To get the debug log see How to collect debug information? document.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I import Joomla users successfully It seems there
is 74 Joomla users registered - I import them and I can check they are correctly registered as Joomla users

When you import Joomla users you have the same ID as in old site? You can export id field along with other fields and in import template on Options tab set Keep ID to Yes so users are created with same id as old site.

headers of file orders for Import which I import are:
email,virtuemart_order_id,order_number,user_currency,payment_element,order_total,order_subtotal,order_tax,order_status_name,order_status

When you have email field the user is searched in Joomla users table for id with email field. Since there are no record for anonymous users in Joomla users table you see Cannot process user, no user ID found message. To solve this instead of email field use virtuemart_user_id field. As mentioned previously if you have Joomla users with same id as your old site you can export virtuemart_user_id from old site for orders so there are no ID conflicts. This will be 0 for anonymous users and there is no check against Joomla users table.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
DarkoF
DarkoF
Accepted Answer Pending Moderation
When I export from old domain user info only 12 users instead of 74 is exported. I can see them in Php My admin but they dont get exported
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!