Hi,

I'm starting a new thread from my "Orders Import With Bestsellers" thread, as there appeared to be an issue with that one.

My background is in IT Project Management, I'm not a developer - Though I'm trying to understand the Abantecart system and would really appreciate your help.

I am new to Abantecart, so really my priorities are understanding how/needing to import orders successfully.

Some of the errors iI got in v1.2.10 to me seem of a similar format to the ones I got in v1.2.11



i.e.

v1.2.10
Missing relation ID order_product_id for update_or_insert action in table order_products
Missing relation ID order_total_id for update_or_insert action in table order_totals.

v1.2.11
Missing relation ID order_id for update_or_insert action in table order_products.
Missing relation ID order_id for update_or_insert action in table order_totals

So I'm guessing I'm missing info from some of the _ID columns, or the columns are not correct for the import,

I've listed the columns I think  are likely to be causing an issue below.
and provided as much detail as possible - though please let me know if there is anything else


Please could you help me to import orders successfully?




i've just upgraded to v1.2.11

I'm migrating  content from  'custom developed' website to Abantecart.

I don't know if there are any issues caused by the upgrade, I guess you'll know more about that than me.


As attached i have:

- Submitted 2 test orders using default stripe test transactions plus a COD transaction and exported them (I've added this data to the top 3 rows in the .csv file attached, just for reference)

- Created an order from actual customer data using the exported file, the customer ID is as exported from Abantecart, the product ID is as exported from abantecart

- attempted a test import of a single order using this data in the Abantecart exported table

- line 5 of the attachment is the single order


I wasn't sure what to do with these columns so :

(B) orders.order_id -  included the column and left this field blank?
(DZ) order_products[0].order_id - included the column and left this field blank?
(EA)order_products[0].product_id - included the column and left this field blank?

And got these results:

(It created 4 duplicate records/entries for the single order, without the associated products)

There will be 1 records loaded and processed in this import!

Task Failed
Import Process has been completed. 0 row(s) processed.
For more details see

2017-09-29 10:30:46 - Converting file /home/username/public_html/dev/admin/system/data/import_phpZyJBRg.txt to array. Start row number: 0. Rows count: 1
2017-09-29 10:30:46 - Starting import data from array. Mode: commit
2017-09-29 10:30:46 - Insert into table orders done successfully
2017-09-29 10:30:46 - Missing relation ID order_id for update_or_insert action in table order_products. Skipping.
2017-09-29 10:30:46 - Missing relation ID order_id for update_or_insert action in table order_totals. Skipping.
2017-09-29 10:30:46 - Missing relation ID order_id for update_or_insert action in table order_totals. Skipping.
2017-09-29 10:30:46 - Converting file /home/username/public_html/dev/admin/system/data/import_phpZyJBRg.txt to array. Start row number: 1. Rows count: 1
2017-09-29 10:30:46 - Starting import data from array. Mode: commit
2017-09-29 10:30:46 - Incorrect structure of main Array node. Only table nodes are expected
2017-09-29 10:30:46 - Converting file /home/username/public_html/dev/admin/system/data/import_phpZyJBRg.txt to array. Start row number: 0. Rows count: 1
2017-09-29 10:30:46 - Starting import data from array. Mode: commit
2017-09-29 10:30:46 - Insert into table orders done successfully
2017-09-29 10:30:46 - Missing relation ID order_id for update_or_insert action in table order_products. Skipping.
2017-09-29 10:30:46 - Missing relation ID order_id for update_or_insert action in table order_totals. Skipping.
2017-09-29 10:30:46 - Missing relation ID order_id for update_or_insert action in table order_totals. Skipping.
2017-09-29 10:30:46 - Converting file /home/username/public_html/dev/admin/system/data/import_phpZyJBRg.txt to array. Start row number: 1. Rows count: 1
2017-09-29 10:30:46 - Starting import data from array. Mode: commit
2017-09-29 10:30:46 - Incorrect structure of main Array node. Only table nodes are expected
2017-09-29 10:30:46 - Converting file /home/username/public_html/dev/admin/system/data/import_phpZyJBRg.txt to array. Start row number: 0. Rows count: 1
2017-09-29 10:30:46 - Starting import data from array. Mode: commit
2017-09-29 10:30:46 - Insert into table orders done successfully
2017-09-29 10:30:46 - Missing relation ID order_id for update_or_insert action in table order_products. Skipping.
2017-09-29 10:30:46 - Missing relation ID order_id for update_or_insert action in table order_totals. Skipping.
2017-09-29 10:30:46 - Missing relation ID order_id for update_or_insert action in table order_totals. Skipping.
2017-09-29 10:30:46 - Converting file /home/username/public_html/dev/admin/system/data/import_phpZyJBRg.txt to array. Start row number: 1. Rows count: 1
2017-09-29 10:30:46 - Starting import data from array. Mode: commit
2017-09-29 10:30:46 - Incorrect structure of main Array node. Only table nodes are expected
2017-09-29 10:30:46 - Converting file /home/username/public_html/dev/admin/system/data/import_phpZyJBRg.txt to array. Start row number: 0. Rows count: 1
2017-09-29 10:30:46 - Starting import data from array. Mode: commit
2017-09-29 10:30:46 - Insert into table orders done successfully
2017-09-29 10:30:46 - Missing relation ID order_id for update_or_insert action in table order_products. Skipping.
2017-09-29 10:30:46 - Missing relation ID order_id for update_or_insert action in table order_totals. Skipping.
2017-09-29 10:30:46 - Missing relation ID order_id for update_or_insert action in table order_totals. Skipping.
2017-09-29 10:30:46 - Converting file /home/username/public_html/dev/admin/system/data/import_phpZyJBRg.txt to array. Start row number: 1. Rows count: 1
2017-09-29 10:30:46 - Starting import data from array. Mode: commit
2017-09-29 10:30:46 - Incorrect structure of main Array node. Only table nodes are expected

Hi
I would like to  Import orders and therefore bestsellers

I've managed to import products and customers, rhou an struggling with orders
as attached, though get this error _



How do I complete this?


Missing relation ID order_product_id for update_or_insert action in table order_products. Skipping.
Missing relation ID order_total_id for update_or_insert action in table order_totals. Skipping.
Missing relation ID order_product_id for update_or_insert action in table order_products. Skipping.
Missing relation ID order_total_id for update_or_insert action in table order_totals. Skipping.

Hi I wonder if you can help me, is there a way to put captions/category descriptions as a rollover/mouseover for category images - i.e. image hover text overlay

Thanks