Import Very Slow

I would try to split the upload file into a smaller files and try again, see if its slow due to the amount of records.

Ok, I am processing 49 orders. It took about 2 and half minutes.
Seems to be moving faster, and not locking down my browser.

But this is not realistic as I said have 13,000 orders to update.

Where does AST store the information in the database?
I did not see it in postmeta.

I don’t neeed it to update order status, i don’t need it to send any emails, i just want the information in the database, so can you tell me where its stored and I will try to enter the data directly?

Thanks

Hello,

We checked adding 50 tracking info with CSV and also we update order status and it took 1 and a half minutes to add. We added tracking information in order meta – ‘_wc_shipment_tracking_items’.

Thanks,

Thank you, but can you please explain some of the values in the field for me:

What type is the date_shipped value stored as?
Where do I get a value for “tracking_id”?

Hi, you never responded to me.

I am just trying to figure out how to build this string:
a:1:{i:0;a:5:{s:17:"tracking_provider";s:11:"israel-post";s:15:"tracking_number";s:13:"MyTrackingNumber";s:12:"date_shipped";s:10:"1206576000";s:14:"status_shipped";s:1:"1";s:11:"tracking_id";s:32:"ddf87c6cfc5bb96faf72a41ac428190a";}}

The 2 variables that are not fully clear are the date_shipped. What format is that?
And the tracking_id, is that just a random guid?

Hi This is array of the tracking number, providers.
As I mentioned, you can do it with the CSV import, it takes much faster then 30 seconds per 1 order, on our system it process a few orders every second..

I have over 39,000 to update

Ok, I understand, but still I would try to create smaller batch and try to import.. can you contact me on zorem.com chat and i will try to help you