Jump to content

query help required for product sales info


Recommended Posts

Using an external database utility, which will show you results from the query, try:

SELECT SUM(`quantity`) FROM `CubeCart_order_inventory` WHERE `product_id` = 6 AND `cart_order_id` BETWEEN '140000' and '141000';

We can use the `cart_order_id` as a very good approximation of the target dates. The values used for the BETWEEN spread are the YYMMDD part of the format. You could use the `product_id`, or if more friendly, use the `product_code`.

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.

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.

  • Create New...