1. davec
  2. RO CSVI
  3. Tuesday, 30 June 2020
  4.  Subscribe via email
Hi

I was wondering if it is possible to create a product stock export including quantities with a date range. Basically looking to export the products list up to the 31st Jan 2020.

Thanks

David
Accepted Answer
Accepted Answer Pending Moderation
Hello David,
The sales start date and end date are probably not applicable to what I am trying to achieve.

That is the only date range i see in terms of product order quantity in HikaShop. Product stock does not have date range.

However using the product created column I get a date format like this 1564155300

Please load the attached patch file and then try the export. Let me know if the patch fixes the date value on export.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Accepted Answer Pending Moderation
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.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
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
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
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.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
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
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello David,
Thank you for confirming that patch is working. This fix will be included in upcoming RO CSVI release.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!