Repository Forums Support Expiry dates for WooCommerce PRO CSV Inventory import Reply To: CSV Inventory import

#2372
Soft79
Keymaster

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?