Repository › Forums › Support › Expiry dates for WooCommerce PRO › CSV Inventory import › Reply To: CSV Inventory import
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?