Jump to content

Exporting Best Selling Products to Excel


toast691
 Share

Recommended Posts

I am just wondering if it is possible to export a list off all products into an excel document listing the qty that has been sold as it is listed in Reporting>statistics>Best Selling Products

I went into SQL database and it lists each products 'popularity' under the inventory tab but it doesn't seem to correspond with the QTY of product that has been sold.

Any ideas?

Link to comment
Share on other sites

That will require an Export module be written.

What would you like the module to report?

The records in CubeCart_order_inventory will have to be scanned, summing up the quantity column of the various items.

Link to comment
Share on other sites

Hi bsmither,

For our purposes I would need product name, product code, category ID & quantity sold. Others may need further information for their needs??

The online function works well but once you have a large product range its slow filtering through all the pages trying to pick out slow selling products.

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...