14 May 2015,12:51 AM #1
- Join Date
- Sep 2008
- Location
- Calgary, AB
- Posts
- 33
- Plugin Contributions
- 0
Differentiate "Sold Out" versus "Out Of Stock"
DEFINITIONS:
Sold Out - an item with 0 quantity that we will NOT be re-ordering and should be disabled (products_status = 0) so it is not found in searches, etc.
Out Of Stock - an item with 0 quantity that we WILL re-order and can stay enabled so it will show up in searches and display as "Out of stock".
QUESTION:
Is there currently a way that I could mark an item as a "Sold Out" item or an "Out Of Stock" item?
Am thinking that the product_type could be used here, but is that over-kill, as we do not need to change anything in the display layout, product info, etc. between the two types?
OR, should I just add a custom field to the products table with a simple 1/0 value?
APPLICATION:
We sell items in our physical store and online, so we run a daily script to update the quantity from our in-store sales tool. Am writing a SQL query to disable any "Sold Out" items that are now 0 quantity while leaving "Out Of Stock" items alone.
Thoughts?
Thanks!My Sewing Room
#148, 8228 Macleod Tr SE, Calgary, AB T2H 2B8
mysewingroom.ca14 May 2015,05:16 AM #2
- Join Date
- Dec 2011
- Location
- Wisconsin, USA
- Posts
- 674
- Plugin Contributions
- 21
Re: Differentiate "Sold Out" versus "Out Of Stock"
Typically items that are "sold out" and not returning to the store are deleted. This eliminates the issue, and it isn't indexable since it isn't present.Originally Posted by MSRWebMaster
DEFINITIONS:
Sold Out - an item with 0 quantity that we will NOT be re-ordering and should be disabled (products_status = 0) so it is not found in searches, etc.
Out Of Stock - an item with 0 quantity that we WILL re-order and can stay enabled so it will show up in searches and display as "Out of stock".
QUESTION:
Is there currently a way that I could mark an item as a "Sold Out" item or an "Out Of Stock" item?
Am thinking that the product_type could be used here, but is that over-kill, as we do not need to change anything in the display layout, product info, etc. between the two types?
OR, should I just add a custom field to the products table with a simple 1/0 value?
APPLICATION:
We sell items in our physical store and online, so we run a daily script to update the quantity from our in-store sales tool. Am writing a SQL query to disable any "Sold Out" items that are now 0 quantity while leaving "Out Of Stock" items alone.
Thoughts?
Thanks!Also to capture those sales of those items that are out of stock I suggest.
https://www.zen-cart.com/downloads.php?do=file&id=194415 May 2015,07:55 PM #3
- Join Date
- Sep 2008
- Location
- Calgary, AB
- Posts
- 33
- Plugin Contributions
- 0
Re: Differentiate "Sold Out" versus "Out Of Stock"
Is it a good thing to actually delete an item? I would worry that that would break any tracking, previous sales, customer history, etc.
(Any DB that I've built or worked on includes a "deleted" field, that indicates if that record has been deleted by an admin-type and shouldn't be shown, but is still in the DB for historical records and keeps the DB cleaner with no missing id numbers.)In the meantime, still need a way to indicate if the product is "deletable" (sold out) vrs one that can stay there.
My Sewing Room
#148, 8228 Macleod Tr SE, Calgary, AB T2H 2B8
mysewingroom.ca15 May 2015,08:08 PM #4
- Join Date
- Dec 2009
- Location
- Amersfoort, The Netherlands
- Posts
- 2,846
- Plugin Contributions
- 25
Re: Differentiate "Sold Out" versus "Out Of Stock"
Ordered products are stored per order line in the 'orders_products' table, so your order history will stay available.
You will lose the info for that product in pages like bestsellers, because the number of times a product is sold is stored in the products tableZen cart installation / maintenance / customisation / hosting
Supported Modules: Dutch language pack, Multi site, Dynamic Price Updater and more.15 May 2015,09:07 PM #5
- Join Date
- Jul 2012
- Posts
- 16,576
- Plugin Contributions
- 17
Re: Differentiate "Sold Out" versus "Out Of Stock"
Well a product can be disabled which will accomplish/complete the above.
As for the "field", while not a global solution, the particular store's use of other aavailable fields could be assessed to see if there is something applicable that could be used, whether an attribute that is not shown to customers or a field elsewhere in the database.
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...21 May 2015,06:34 AM #6
- Join Date
- Dec 2011
- Location
- Wisconsin, USA
- Posts
- 674
- Plugin Contributions
- 21
Re: Differentiate "Sold Out" versus "Out Of Stock"
I agree with disabling the product, is a good solution.Originally Posted by mc12345678
Well a product can be disabled which will accomplish/complete the above.
As for the "field", while not a global solution, the particular store's use of other aavailable fields could be assessed to see if there is something applicable that could be used, whether an attribute that is not shown to customers or a field elsewhere in the database.
However the issues becomes when stores that have thousands of products have all these discontinued products it really creates un-need bloat, and since the products are stored in the TABLE_ORDERS_PRODUCTS it shouldn't be an issue. Unless a programmer wasn't aware or too lazy to use that table.
21 May 2015,01:17 PM #7
- Join Date
- Aug 2005
- Location
- Arizona
- Posts
- 27,762
- Plugin Contributions
- 9
Re: Differentiate "Sold Out" versus "Out Of Stock"
Not sure what scripting you are using but in the products table one can alter the "product_status" field from "1" to a "0" to turn a product offwe run a daily script to update the quantity from our in-store sales tool
Zen-Venom Get Bitten
21 May 2015,02:13 PM #8
- Join Date
- Jul 2012
- Posts
- 16,576
- Plugin Contributions
- 17
Re: Differentiate "Sold Out" versus "Out Of Stock"
This does/can work for reports on product purchased, but then I don't recall that the products viewed report has an independent table of record of views as I thought that was tracked with the product. Then if the product is deleted, assessment data is then lost preventing the ability to see what things "visitors" took interest.I agree with disabling the product, is a good solution.
However the issues becomes when stores that have thousands of products have all these discontinued products it really creates un-need bloat, and since the products are stored in the TABLE_ORDERS_PRODUCTS it shouldn't be an issue. Unless a programmer wasn't aware or too lazy to use that table.
Of course it depends on the store and product if there is any value in having that information, at what periodicity it provides value, etc...
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...27 May 2015,01:07 AM #9
- Join Date
- Sep 2008
- Location
- Calgary, AB
- Posts
- 33
- Plugin Contributions
- 0
Re: Differentiate "Sold Out" versus "Out Of Stock"
Thanks for the replies.
So, just to clarify my intent. I will use the existing product_type field to indicate what type of product it is (0 = a "sold-out" item, 1 = an "out-of-stock" item).
My script will find all products where inventory = 0, then check the product_type:This way a user will still see any out-of-stock items that we intend to re-order. and not find any sold-out items that will not be returning to our store.Code:
if (product_type == 0) then set products_status = 0else set products_status = 1
Guess I just need to see if using the product_type field like this alters anything in the display of the items. Thanks again.My Sewing Room
#148, 8228 Macleod Tr SE, Calgary, AB T2H 2B8
mysewingroom.ca28 May 2015,10:02 AM #10
- Join Date
- May 2015
- Posts
- 6
- Plugin Contributions
- 0
Re: Differentiate "Sold Out" versus "Out Of Stock"
I need whole changes how to set a product OUT OF STOCK not a sold out .
If all my product sold out then don't show the message sold out , message should be out of stock with product details.
Please help anybody its urgent Thanks.Last edited by SameerSam; 28 May 2015 at 10:04 AM.
Differentiate "Sold Out" versus "Out Of Stock" (2024)
Table of Contents
Differentiate "Sold Out" versus "Out Of Stock"
Re: Differentiate "Sold Out" versus "Out Of Stock"
Re: Differentiate "Sold Out" versus "Out Of Stock"
Re: Differentiate "Sold Out" versus "Out Of Stock"
Re: Differentiate "Sold Out" versus "Out Of Stock"
Re: Differentiate "Sold Out" versus "Out Of Stock"
Re: Differentiate "Sold Out" versus "Out Of Stock"
Re: Differentiate "Sold Out" versus "Out Of Stock"
Re: Differentiate "Sold Out" versus "Out Of Stock"
Re: Differentiate "Sold Out" versus "Out Of Stock"
Top Articles
Capital Gains Tax: What to Know - ComparisonAdviser
The downs and ups of capital gains tax
Lolo Hdcam
Attorney General James Announces Indictments of Rensselaer and Orange County Medical Transport Companies for Stealing over $4.4 Million From Medicaid
Victory Hôtel Galou (Paris)
Victory Hotel Galou ab 46 €. Hotels in Paris - KAYAK
Telestaff Pasco
Printf Hex
Best Lawn Grass For North Texas - Green Packs
Wi Dept Of Regulation & Licensing
Dan's Daily: Trades Begin; Big Contracts Delivered; Penguins Scoring Options
Masters: Jett Luchanko refuses to get caught up in his own NHL draft buzz | TSN
Latest Posts
Is Travel Insurance Worth It? — LEGACY CENTRIC
Capital gains: Sunak and Starmer’s tax bills show how the system benefits the rich
Article information
Author: Neely Ledner
Last Updated:
Views: 6167
Rating: 4.1 / 5 (62 voted)
Reviews: 85% of readers found this page helpful
Author information
Name: Neely Ledner
Birthday: 1998-06-09
Address: 443 Barrows Terrace, New Jodyberg, CO 57462-5329
Phone: +2433516856029
Job: Central Legal Facilitator
Hobby: Backpacking, Jogging, Magic, Driving, Macrame, Embroidery, Foraging
Introduction: My name is Neely Ledner, I am a bright, determined, beautiful, adventurous, adventurous, spotless, calm person who loves writing and wants to share my knowledge and understanding with you.