Hi Abantecart,

I've attached the orders file, its afairly simple format and as exported from the site/imported into open office.

Yes I don't know the correct way to add values to the ID columns, so I've left them blank, for the purpose of attaching the file and would appreciate some direction.

Hi,

I've exported a single record and opened with openoffice ...comma separated, text deelimited " and all columns set as 'text.'

Tested a simple update of the name  as attached- and this worked fine though still get that error at the end - "Incorrect structure of main Array node. Only table nodes are expected"


2017-10-06 17:02:15 - Converting file /home/user/public_html/dev/admin/system/data/import_phpCKrjH5.txt to array. Start row number: 0. Rows count: 1
2017-10-06 17:02:15 - Starting import data from array. Mode: commit
2017-10-06 17:02:15 - Update for table orders done successfully
2017-10-06 17:02:15 - update for table order_history done successfully
2017-10-06 17:02:15 - update for table order_history done successfully
2017-10-06 17:02:15 - update for table order_products done successfully
2017-10-06 17:02:15 - update for table order_totals done successfully
2017-10-06 17:02:15 - update for table order_totals done successfully
2017-10-06 17:02:15 - Converting file /home/user/public_html/dev/admin/system/data/import_phpCKrjH5.txt to array. Start row number: 1. Rows count: 1
2017-10-06 17:02:15 - Starting import data from array. Mode: commit
2017-10-06 17:02:15 - Incorrect structure of main Array node. Only table nodes are expected

Hi Abantecart, Ok, points taken! Haha - Thanks, I'll take another look, my learning curve here is a little steep

Hi Bassara thank you for the guidance, I'll try that suggestion.

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 abantecart,

As far as I realised, I'm doing exactly the same thing, just this time with the upgrade. And I gave more detaii.

It's only for tthe orders import, whiich I would like to populate the bestsellers list. (I'm guessing if done properly, it will).

Just this time I gave more detail

Re: "Try to export one order, this will give you correct table" (Basara,)

I've exported 3 orders (this time , ones I've submited, instead of the default demo data) with the correct  table (this time the full table), which is in the .csv attachment

And added the single order i've tried to import ...and then gave the column issues + results


On the original question the first .csv attachment is of the single order I tried to import, except Id looked at the demo data and removed the columns I didn't think I needed


 just tried to give more detail

Hence the error I'm getting is very similar... Missing relation ID order_product_id


Happy of course to start a new thread, just clarifying

Great thats good news thank you !

Hi Basara,

Yes I did that,

What do I put in these columns order_product_id
and order_total_id (for total))

Thanks

Hello

Thanks for your reply as it suggested that this was managed in the layouts somewhere, rather than just the code perhaps.

You were of course correct, its managed by the 'default page layout.'  I had "deleted any individual category layout changes" thou I hadn't deleted the actual 'individual category layouts' so there was an overide.

Re: "I can't see a way of creating a default category layout in admin"
I would like to do this rather than use the 'default page layout' - is this possible in admin?
Can the the default category layout assigned to an 'admin layout' somewhere in the code....Or something else?
Could you point me in the right direction for this please. I've located the .tpl files in the storefront directory, looking at cloning and editing files, and getting my head around the set up/architecture. Would this need to be done via a new template perhaps?

I would appreciate any help with this, thanks