Resolved Hikashop Product Stock Export

Hello David,
Thank you for confirming that patch is working. This fix will be included in upcoming RO CSVI release.

Good morning

the patch has worked reference the date format, thanks very much.

I think this may be all that is now required.

Thanks very much for your help

David

Hi

I have attached a screenshot of the fields I was intending to use for the product export from within CSVI. The sales start date and end date are probably not applicable to what I am trying to achieve. However using the product created column I get a date format like this 1564155300


Thanks

David

Hello David,

I cannot see the option for dates in Quantity unless I am missing something?

If you are talking about Quantity field in HikaShop(See screenshot) then it does not have option for dates. The only option i see for dates is for Quantity per order for a product. Can you send me a screenshot on which Quantity you are looking for?

Also adding a date format, is this how it would appear in the CSV export (screenshot attached)

Date format is applicable only for date fields on export. So for example if a date is stored as 2020-07-01 23:34:12 in database with the date format you have set (d-m-y) in template fields page, export will get the date value as "01-07-20" in export file.

Good morning

thanks for your reply. I cannot see the option for dates in Quantity unless I am missing something? Also adding a date format, is this how it would appear in the CSV export (screenshot attached)

Sorry of I am missing the point!

David

Hello David,
There is no separate export for product stock but you can do that using HikaShop Product export. You can use product_quantity field for the available stock, product_min_per_order, product_max_per_order, product_sale_start and product_sale_end(see screenshot) fields for quantities with a date range. Only issue is that there is no option to set a filter for exporting products till 31st Jan 2020 in the template.