inventory tracking by product ordering option

General ShopSite user discussion

inventory tracking by product ordering option

Postby Rodney Blackwell » Mon Jun 06, 2005 5:54 pm

For example, I sell t-shirts in different sizes, it would benefit me to know
if I am low on a particular *size*, rather than on the product as a whole.

IE: If I have 1 small, 10 mediums, 50 larges, and 1 XLarge of the "blue dog
t-shirt"

I would need to know that I'm running low on SMALLS and XLARGES, even though
I have a lot of inventory of the product as a whole (62 total shirts of that
style). That way I can get a low inventory notification to let me know I
need to reorder smalls and xlarges. Customers could see a message that just
those sizes are out of stock.

Is there a way for shopsite to keep track of inventory based on the
pull-down menu ordering option (like Small/Medium/Large, etc)?

If not, anybody know of a module that will do this?

Thanks,

Rodney
Rodney Blackwell
 

Re: inventory tracking by product ordering option

Postby jim » Mon Jun 06, 2005 9:14 pm

The only way to keep track of each size by count is to have each size be
its own product. So using the ordering options will not give you this
functionality.
You can however make a custom template that will list subproduct in a
pulldown similar to order options. What you would then do is create
your master product Blue Dog T-Shirt and have subproducts of small,
medium, large, x-large. Each of the subproducts would have its own
quantity. Each would also need to have its own SKU so that you could
tell the difference between a small Blue Dog T-Shirt and a small Blue
Cat T-shirt since both would just have the name of Small.

I can't find a sample of the way you would create the template here at
home but I'll look for one when I get to the office tomorrow and post
it. If you want to see a site using such a template go to
http://www.carvaluesplus.com/store/chevrolet.html
They sell covers for cars and have several different sizes. They have
the covers broken out by size for each make, model and year as a
separate product. The template displays them in a list as subproducts
similar to the way order options work. That way they can keep track of
inventory of exactly which sizes they sell.

Jim

Rodney Blackwell wrote:
For example, I sell t-shirts in different sizes, it would benefit me to know
if I am low on a particular *size*, rather than on the product as a whole.

IE: If I have 1 small, 10 mediums, 50 larges, and 1 XLarge of the "blue dog
t-shirt"

I would need to know that I'm running low on SMALLS and XLARGES, even though
I have a lot of inventory of the product as a whole (62 total shirts of that
style). That way I can get a low inventory notification to let me know I
need to reorder smalls and xlarges. Customers could see a message that just
those sizes are out of stock.

Is there a way for shopsite to keep track of inventory based on the
pull-down menu ordering option (like Small/Medium/Large, etc)?

If not, anybody know of a module that will do this?

Thanks,

Rodney

jim
 

Re: inventory tracking by product ordering option

Postby jim » Mon Jun 06, 2005 9:37 pm

Here is the template that I mentioned in my other message. It may need
a little modification to meet your needs but should give you the general
idea.
Jim
#=================================
[-- DEFINE SUBPRODUCT --]
# A subproduct in this template is just an option for a pull down list
# Note1: Field1 is used to hold the name used for the pull down list
# such as "Brown, Size 8" instead of the actual name which
# might be "Wing Tip - Brown, Size 8".
# Note2: In order to turn off the master:subproduct naming feature
# used
# by ShopSite's shopping cart check the box
# Display subproducts without parent name:
# Under Commerce Setup > Order System > Shopping Cart
#
[--IF PRODUCT.SaleOn--]
<option value="[--PRODUCT.RECORDNUMBER--]">[-- PRODUCT.FIELD1 --] [--
PRODUCT.S
aleAmount --]</option>
[-- ELSE --]
<option value="[--PRODUCT.RECORDNUMBER--]">[-- PRODUCT.FIELD1 --] [--
PRODUCT.P
RICE --]</option>
[-- END_IF --]
[-- END_DEFINE SUBPRODUCT --]

[-- DEFINE PRODUCT --]
<CENTER>
[--PRODUCT.Name--]
<br>
[-- IF product.subproduct --]
<form action="[-- SHOPPING_CART_URL BASE --]/order.cgi" method=post>
<input type=hidden name=storeid value=[--Store.id--]>
<input type=hidden name=dbname value=products>
<input type=hidden name=function value=add>
<TABLE>
<TR><TD>
<SELECT name=itemnum>
[-- LOOP SUBPRODUCTS --]
[-- SUBPRODUCTS --]
[-- END_LOOP SUBPRODUCTS --]
</SELECT></TD><TD>
<input type=image src="[-- OUTPUT_DIRECTORY_URL
--]/media/add_to_cart.gif" width
=83 height=20 alt="add_to_cart.gif" hspace=3 vspace=3 border=0
align="bottom" na
me="Add to Cart" alt="Add to Cart">
<input type=image src="[-- OUTPUT_DIRECTORY_URL --]/media/view_cart.gif"
width=7
1 height=20 alt="view_cart.gif" hspace=3 vspace=3 border=0
align="bottom" name="
View Cart" alt="View Cart">
</TD></TR></TABLE>
</form>

[-- ELSE --]
# Need to treat as regular product
# this code still needs to be added
[-- END_IF --]
</CENTER>

[-- END_DEFINE PRODUCT --]
[-- DEFINE MORE_INFO_PAGE --]
[-- END_DEFINE MORE_INFO_PAGE --]
#======================================

Rodney Blackwell wrote:
For example, I sell t-shirts in different sizes, it would benefit me to know
if I am low on a particular *size*, rather than on the product as a whole.

IE: If I have 1 small, 10 mediums, 50 larges, and 1 XLarge of the "blue dog
t-shirt"

I would need to know that I'm running low on SMALLS and XLARGES, even though
I have a lot of inventory of the product as a whole (62 total shirts of that
style). That way I can get a low inventory notification to let me know I
need to reorder smalls and xlarges. Customers could see a message that just
those sizes are out of stock.

Is there a way for shopsite to keep track of inventory based on the
pull-down menu ordering option (like Small/Medium/Large, etc)?

If not, anybody know of a module that will do this?

Thanks,

Rodney

jim
 

Re: inventory tracking by product ordering option

Postby Rodney Blackwell » Tue Jun 07, 2005 2:15 pm

Wow Jim, thanks for that info (and template sample)!

I'll need to read and re-read your post a few times to let it sink it. It
seems like it would work perfectly for my needs...it's just so "out of the
box", I don't think I would have ever thought of it on my own.


"jim" <jstavast@xmission.com> wrote in message
news:d836ud$7ij$1@eval.shopsite.com...
The only way to keep track of each size by count is to have each size be
its own product. So using the ordering options will not give you this
functionality.
You can however make a custom template that will list subproduct in a
pulldown similar to order options. What you would then do is create your
master product Blue Dog T-Shirt and have subproducts of small, medium,
large, x-large. Each of the subproducts would have its own quantity.
Each would also need to have its own SKU so that you could tell the
difference between a small Blue Dog T-Shirt and a small Blue Cat T-shirt
since both would just have the name of Small.

I can't find a sample of the way you would create the template here at
home but I'll look for one when I get to the office tomorrow and post it.
If you want to see a site using such a template go to
http://www.carvaluesplus.com/store/chevrolet.html
They sell covers for cars and have several different sizes. They have the
covers broken out by size for each make, model and year as a separate
product. The template displays them in a list as subproducts similar to
the way order options work. That way they can keep track of inventory of
exactly which sizes they sell.

Jim

Rodney Blackwell wrote:
For example, I sell t-shirts in different sizes, it would benefit me to
know if I am low on a particular *size*, rather than on the product as a
whole.

IE: If I have 1 small, 10 mediums, 50 larges, and 1 XLarge of the "blue
dog t-shirt"

I would need to know that I'm running low on SMALLS and XLARGES, even
though I have a lot of inventory of the product as a whole (62 total
shirts of that style). That way I can get a low inventory notification to
let me know I need to reorder smalls and xlarges. Customers could see a
message that just those sizes are out of stock.

Is there a way for shopsite to keep track of inventory based on the
pull-down menu ordering option (like Small/Medium/Large, etc)?

If not, anybody know of a module that will do this?

Thanks,

Rodney
Rodney Blackwell
 


Return to User Forum

Who is online

Users browsing this forum: No registered users and 21 guests