[Out of stock] Inform me when available again [Report]

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
1 ano atrás
Hi! i'm looking but can't find. Is somewhere in NOP 4.40.04 information about people who are waiting to some stock?

How this could look.
I go to report and see 100 CLients waiting on product X... 50 for another... so i include this when make order.

Can i find somewhere something similar or need custom?
1 ano atrás
you will not find for all customer at once out of the box. only one by one  is available now from admin -> customer -> edit -> Back in stock subscriptions
you can execute this sql by date range to get all in once
SELECT
  p.Name
  ,p.sku
    ,c.Username
    ,c.Email
    ,biss.[CreatedOnUtc]
    ,[StoreId]
    ,[ProductId]
    ,[CustomerId]
    ,p.[Id]
  FROM [BackInStockSubscription] biss
  INNER JOIN [Product] p ON p.id = biss.ProductId
  INNER JOIN [Customer] c ON c.Id = biss.CustomerId
  where biss.CreatedOnUtc between '2022-01-14 00:00:00.0000000' and '2022-02-14 23:59:59.9999'


useful link 1.https://www.nopcommerce.com/en/boards/topic/28039/enhancement-show-back-in-stock-subscriptions-to-admin-panel
2.https://github.com/nopSolutions/nopCommerce/issues/4559
3.https://github.com/nopSolutions/nopCommerce/issues/4955
1 ano atrás
Thanks!
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.