Messages

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

Created a record from the exported file, and tested a single import.
Unfortunitely got exactly the same erro as started with.

it does seem, that I need to know what to do with these colums?:

orders.order_id
order_products[0].order_id
order_products[0].product_id

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

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

Simple export of one record via abantecart admin, and import as text as per https://www.hesa.ac.uk/support/user-guides/import-csv and file was still messed up with unreadable chars, I don't think its anything I'm doing, as pretty straightforward, so will try openoffice

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.

Hello Basara,Abantecart

Thank you for your responses, I'm using/saving in Excel 2013 to edit the .csv files

Had a look at unreadable chars in wizard are -   - and - £ - pounds signs opened/translated in Excel as  for me.  I tried £,  and without. though still getting the same errors on the import.

I don't really have an idea about the structural issue , the file and attachment is opening ok for me in Excel. I'm not doing anything different with the orders compared to products and customers export/import. Products and customers imported ok without any apparent structural issue in v1.2.10.

I started from scratch, read that if adding/changing columns this may add commas in excel, I may have done this while testing (though did same with products and customers in 1.2.10 ok). Simply exported by ID this time (simplified/less columns for my products), edited  and imported, keeping as .csv format. Though same "Incorrect structure of main Array node. Only table nodes are expected" error. if thats the error.

Also of course missing relation ID for missing values in ID columns - so far I've included/though left the columns listed below blank.

- I've attached the latest file, removing £ or Â

I've had a look at the tables in the database via phpmyadmin
Perhaps could import directly into database?

Though would need a little help with the ID columns

Order ID columns - straightforward numerical order (unique)?
orders.order_id
order_products[0].order_id
order_totals[0].order_id

- Can follow existing sequence for these as exported?
order_totals[0].order_total_id
order_totals[1].order_total_id

- can't see logically where this ID for each order/products comes from, or anywhere else it's referenced in the database?
order_products[0].product_id

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

I did upgraded from v1.2.10 to v1.2.11 before doing the 2nd import for an order record

- So the the first set of results is via 1.2.10 and the 2nd set of error results are via the 1.2.11 import wizard (which is returning more errors, though including similar ones i had the first time)

- Perhaps this is complicating the issue?

I just really need to know how to import orders successfully - so I'm providing the results I'm getting

Happy to start a new thread for importing orders in v1.2.11

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

Hi,

I'm still having problems with this, please can you help.

i've just upgraded to v1.2.11

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


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

Great thats good news thank you !

Hello,


I've installed the default stripe extension, and cretit card details appear to be entered onsite and on 'mywebsite' server, rather than on the stripe server.

With the default Stripe extension does any processing, or transmission of any cardholder data take place on 'my sites' server and then passed to the Stripe server? Or are credit card details entirely entered and processed on the Stripe server ?

I need to understand this as i'm in the UK,  and need to know if its PCI DSS compliant and eligible for  PCI SAQ A? UK <a href="https://www.pcisecuritystandards.org/pci_security/completing_self_assessment"> PCI Self Assessment Criteria</a>

I'm considering both the Default and Advanced Stripe options.

Thanks

Hi Basara,

Yes I did that,

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

Thanks

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.

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