CSV Inventory import

[amt]

Hi,

I have a stock of +9000 different products each with expiry date.

Is there a way to import the data using CSV?

Note: after installing expiry date plug in and manually setting the expiry date for one product, I exported a CSV file and noticed that the plugin stores the data as a whole number (not formatted); is there a way to convert my dates to the same “unformatted number” so I can import them?

-Eid

[Soft79]

Hi,

it’s a unix timestamp (the amount of seconds since 1-1-1970).
Online converter: https://www.epochconverter.com/
See: https://www.extendoffice.com/documents/excel/2473-excel-timestamp-to-date.html to convert using Excel.

Please note that you need to import both the _j79_wcxd_expiry_date as _j79_wcxd_expiries meta values.

If you need only one expiry date per product, with no amount (i.e. all products same expiry date) you can use this format for _j79_wcxd_expiries: a:1:{i:0;a:2:{s:4:"date";i:1532476800;s:8:"quantity";s:0:"";}} (replace 1532476800 by the actual timestamp).

I will make export/import easier in the next version. This question has been asked a couple of times.

What import tool are you using?

[Author]

Posts