Import Very Slow

  • Resolved yonahs

    (@yonahs)


    5 years, 8 months ago

    I am migrating my existing custom site over to wordpress/woocommerce.

    Right now, I have a list of about 13,000 tracking numbers that I need to import.
    I tried using the Import CSV file, but it goes very slow, about an order every 30 seconds and it totally freezeq my computer.

    Any other suggestions on how to do this?

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Zorem

    (@zorem)

    5 years, 8 months ago

    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.

    Thread Starter yonahs

    (@yonahs)

    5 years, 8 months ago

    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

    Plugin Author Zorem

    (@zorem)

    5 years, 8 months ago

    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,

    Thread Starter yonahs

    (@yonahs)

    5 years, 8 months ago

    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”?

    Thread Starter yonahs

    (@yonahs)

    5 years, 7 months ago

    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?

    Plugin Author Zorem

    (@zorem)

    5 years, 7 months ago

    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..

    Thread Starter yonahs

    (@yonahs)

    5 years, 7 months ago

    I have over 39,000 to update

    Plugin Author Zorem

    (@zorem)

    5 years, 7 months ago

    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

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Import Very Slow’ is closed to new replies.

Tags