Repository Forums Support Expiry dates for WooCommerce PRO CSV Inventory import

Topic Resolution: Resolved
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • #2371


    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?




    it’s a unix timestamp (the amount of seconds since 1-1-1970).
    Online converter:
    See: 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?

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.