Waitlist entries are not exported

  • Posts: 28
  • Thank you received: 0
9 years 3 months ago #209426

-- HikaShop version -- : 2.5.0
-- Joomla version -- : 3.4.3
-- PHP version -- : 5.5.27
-- Browser(s) name and version -- : Google Chrome

Hi,

If I export my products from the backend, there are no data for waitlist exported. All products are listed with zero even there are waitlist for some of them.
Why?

Thanks,

Claus.

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
9 years 3 months ago #209430

Hi,

Because the waitlist data is not stored in the product table but in the "waitlist" table and the HikaShop import/export are not handling that table.
And I don't think that's a good idea to add the waitlist data in the product export ; I think it's better to have just an export of the waitlist. I will add a request in the TODO list.
You can access to the waitlist data in the HikaShop backend, under "Customer > Waitlist".

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: clucking

Please Log in or Create an account to join the conversation.

  • Posts: 28
  • Thank you received: 0
9 years 3 months ago #209570

Okay. But actually I would like just to have the wait-list quantity exported together with the stock quantity since I want to use it as basis for my own filling up orders. So a sum of the quantities in the wait-list per product is preferred. And the field is already there when the products are exported - but with zero as the quantity :(

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 3 months ago #209587

Hi,

The quantity field is indeed already in the export and with the value 0 if the product is out of stock. That's normal.
As Jerome said the waitlist quantity is not exported. There is actually no such data anywhere in the database.
You only have all the waitlist entries in the hikashop_waitlist table (one line per product, per customer requesting a notification).
So it would require an extra query to do the calculation dynamically during the export, so it's actually not that simple.

Please Log in or Create an account to join the conversation.

Time to create page: 0.058 seconds
Powered by Kunena Forum