Skip to main content
Skip to main content
Skip to main content
Skip to main content
Skip to main content

How can we help?

Enter whatever you're curious about and we'll give you a smart summary of the best answers as well as relevant articles.
3


[{id=191604258920, createdAt=1750439292853, updatedAt=1753712801754, path='product-page-3-0-part-3-variants', name='Product Page 3.0: Part 3 - Variants', 16='{type=list, value=[{id=4, name='music_shop_360', order=3, label='Music Shop 360'}]}', 2='{type=string, value=https://rainpos.my.site.com/s/article/Product-Page-3-0-Part-3-Variants}', 4='{type=list, value=[{id=1, name='rain_pos', order=0, label='Rain POS'}, {id=2, name='like_sew', order=1, label='Like Sew'}, {id=3, name='jewel360', order=2, label='Jewel360'}]}', 21='{type=number, value=0}', 6='{type=string, value=

Setting Up Variants in a Product

If you are working with a product that will have variants of different sizes, colors, and/or styles, it is critically important to set the product to have Variants before you save it for the first time. You can do this by switching on the Variant toggle in the upper right, as pictured below.

For your core product details for variants including identifier codes such as SKUs, pricing, and images, you will work on the Product Information tab.

Please Note: You MUST set the Variant toggle before saving the product for the first time or the option will no longer be available for that product. We have set it up this way because when we allowed it to be changed after saving previously, it was making bad data and causing problems.

  1. Variant Toggle - Be sure to turn this on before you save the product for the first time. If you forget, you cannot change it later and will have to delete and recreate the product. 
  2. Variant Group Name - This will be major divisions of your variants such as Size, Color, Style, etc. You can have multiple variant groups if needed, but it's recommended not to create more than three.
  3. Variant Options - You can add as many variants as needed, and in this version of the Product page there is no need for side-scrolling, so you'll be able to see all variant options you create in a stack, as pictured below. You can drag and drop your variant options into whatever order you need them to appear.
  4. Save Variant - The Save button doesn't save the whole product, but does save whatever variant group you have created. It is necessary to save it in this way in order for the Variant Image area to show up. It is also necessary to save here before saving the product at the bottom of the page.
  5. Variant Groupings - You can click to expand or collapse any variant group you have created. Only one can be open at a time.
  6. Add a Variant - This will add a new variant group to the product.
  7. Edit - Once you have saved a variant group, you can click this button to Edit anything about it. It can be renamed or removed if you don't need it. When editing a variant, you will also see any variant options you've created, and you can edit their names or delete them as needed.

 

Adding Variant Product Details

For each of your variants you are able to enter core information such as identifier codes, weight, dimensions, condition, and finish / color, as indicated below:

  1. Location - If you have multiple store locations, they will be listed here, and you can add the data detailed below and have it apply to just the current specified location or to all of them.

  2. Search - If you're working with a lot of variants / combinations, you can search them here by entering keywords and clicking the search button.

  3. Variants - For each variant group in the product, you'll have a tab in this area. You can either work within the group, which will change the view to group all variant options under that group as pictured below, or work with All at once and see a master list of all variants.

  4. Print Label - If you click this button at the top, it will load a label line item for every variant in the product, as pictured below. If you are viewing a specific variant, it will also have this button, and it will load only that variant for print. All line items will default to print one label, but you can set whatever quantities you need.

  5. View Options - This function controls what optional data you want to see. Options include Show Items with 0 Inventory, which is on by default, and Show Deactivated Items. Set these the way you want, and then click Done.

  6. Open / Close Variant Option - Clicking this arrow will expand the variant option so you can enter data for it. When this is open, you are able to add a Variant image on the right. If all variant options are closed, that area does not display and you can only have one open at a time.

  7. Product Identifier Codes - These include UPC, Manufacturer Number, and SKU. If you have created the product from the Catalog and if that catalog works with variant data, the available identifier codes will already appear here. Even without the catalog, the system will populate a unique SKU for each variant you create, and you can either use the pre-generated SKUs or you can change it to whatever is needed. Any time you click on one of these codes, if you have multiple locations, you will have the option to Apply to All Store Locations.

  8. Alternate Barcode Title - By default, when you print a barcode label, the title for the barcode itself will be the Product Title Plus Variant Name, but if you want to display something different on the label for the product you can enter an Alternate Barcode Title here and the system will use that when printing the label for the variant.

  9. Alternate Lookups - If you have alternative names for a variant that you use internally, you can enter those terms here and when searching for the items anywhere in the system, e.g. Register, Products page, etc., the item will come up in searches using those terms.

  10. Product Weight & Dimensions - You can enter weight and dimension values for your variant in this area. These will use your store default measurement system, which will either decimal values of pounds or kilograms for Weight, inches or centimeters for Height, Width, and Length. The values you enter here for weight will work with system weight-based shipping methods. The values you enter for weight and dimensions will work for our integrations with Shipstation, Reverb, and Shopify.

  11. Condition - If you have non-serialized Conditions enabled (under Settings > Website Settings > Products) you can select the Condition of the variant here. Conditions include Brand New, Like New, Mint, Excellent, Very Good, Good, Used, Fair, Poor, Non-Functioning, and Floor Model.

  12. Finish / Color - If the item has a special Finish, e.g. glossy or matte, or a particular Color, you can enter a brief description here of those features.

  13. Variant Media - Whenever you have expanded the detail area of a variant, the Variant Media area will be visible. You can upload an image file here to represent the variant. Only one image per variant is allowed. Recommended formats are JPG, PNG, and WebP. Images that are 2k pixels wide are recommended, with a file size less than 4mb. If you want an animated image, you can use a GIF file as long as it's less than 4mb. Please see the post about Images for further details on best practices for the images you upload.

 

Adding Variant Product Pricing

Please note that for all values entered in this area, you have the option of applying each to all Store Locations, all Variants, or All Variants and Locations, which can save you a lot of data entry time.

In the Pricing area, you are able to add unique values for the variant you are editing for the following price fields:

  1. Price - The standard selling price for the item.
  2. Sale Price - If the item is part of a Scheduled Sale, or if you want to enter a price discounted from the regular Price, you can do so here.
  3. MAP Price - If the maker of the product lists a Minimum Advertised Price you need to respect, entering that price here will help you make sure your pricing does not go below MAP if you run a sale or do a bulk price edit. Doing any bulk activity or trying to save a price lower than MAP Price here will pop up a warning letting you know so you can avoid violating price agreements with your manufacturers. PLEASE NOTE: This feature is available only in version 3.0 of the Product Page or later.
  4. Website Price - If you have pricing you use on your website that is different from in-store pricing, this optional field allows you to list your standard price for web sales for the variant. If you do not use this field, the regular Price field will be used for both in-store and website sales.
  5. Website Sale Price - Again, if you use pricing that is different on your website from in-store prices, this field will allow you to list a discounted sale price from your Website Price for online sales only. If you don't use this field, the regular Sale Price field will be used for both in-store and website sales.
  6. Reverb Price - If you use the Reverb integration, you can list the price the system will use on Reverb for the item here, and it can be different from any of the above prices.
  7. Shopify Price - Shopify doesn't need dedicated pricing fields. If you use the Shopify integration, it will use whatever active pricing you have set. So if you only list a Price and Sale Price, those will display on your Shopify site. If you use Website Price and Website Sale Price, whatever is active for the product will display on Shopify.

 

Adding Variant Purchasing Information

For each Vendor you have added to the product, you will be able to set the Purchasing information listed below:

  1. Vendor Name - Each Vendor you have listed for the product (which is set in the upper section of the Product Information tab) will be listed here, with the Primary Vendor at the top. If you need to change your Primary Vendor, you can do so a the top of the page.
  2. Vendor Part Number - If the vendor has a specific part number they use, you can save that here and it will appear in relevant areas of the system such as the Inventory and Low Inventory reports, and on your Purchase Orders and Receiving Orders for the item.
  3. Packaging Quantity - If the vendor always sends the item packaged a specific way, you can list the quantity in that packaging here.
  4. Packaging Unit Type - If the item's Unit Type is relevant, you can list it as being a number of Items, Inches, Feet, Yards, or Meters.
  5. Packaging Container Type - If the package container is a Case, Bolt, Box, Roll, or Pack, you can specify that here.
  6. Apply To - All specific vendor data for the variant can be applied to all Store Locations, Variants, or to all Variants and Locations to save you data entry time.
  7. Default Cost - This value will apply to the variant and will be used when doing a new Purchase Order for the item. Please note, this value is NOT used in reporting. The actual Cost you enter for each time you receive or add inventory to the variant will be listed on the Inventory tab for the item and the reporting will use that cost to determine your inventory value and profit margins.
  8. Reorder Point - If you want this product to be included in our automated reordering recommendations, you will want to set the Reorder Point value. When the product's inventory gets down to this value, it will appear on the Low Inventory report or in the Low Inventory view of the main Inventory report. It will also display in the Purchase Queue when doing a Purchase Order for any of the Vendors saved for the product.
  9. Desired Stock Level - Again, if you are wanting this product to be included in our automated reordering recommendations, you can set a Desired Stock Level. When adding the item to a Purchase Order or Receiving Order, the system will make sure the quantity being ordered will result in an inventory level that is at or above the number entered here. For example, If the product pictured above is down to 1 item in stock and it's added to a Purchase Order, the system will recommend ordering a case of 8 items, which will bring the stock level to 9.

 

Adding Inventory to Your Variants

On the Inventory tab for the product, each of your variants will have an area for entering inventory quantities and costs and for tracking inventory history events, as detailed below.

  1. Inventory Tab - To work with the variant quantities and cost, click on the product's Inventory tab.
  2. Location - You will work with specific inventory quantities and costs for a single location at a time if you have multiple locations saved in the system. You can easily switch between locations using these tabs at the top.
  3. Search Variants - Each variant you have saved for the product will be listed below and you can search and jump to the one you want from here.
  4. View Options - You have some view options for this area that allow you to Show Items with Zero Inventory and Show Deactivated Items. By default, you won't see deactivated variants and you will see items with zero inventory.
  5. Variant Inventory Expand / Collapse - Click here to expand or collapse the full Inventory info area for the variant. Only one variant can be open at once.
  6. Active Location - The location you are working with will be highlighted here, you can change to a different location using the tabs at the top.
  7. Add New Inventory Quantity - If you wish to manually add inventory quantity to the variant at the active location, enter the quantity here. For items that sell by the yard or meter, this can be entered as a decimal value for fractional yardage / meterage.
  8. Cost Per Item - When adding new inventory to the variant, enter your base cost for the item here. The cost should be entered for a full yard or meter for items sold that way. This amount is calculated and added for you whenever entering inventory via Receiving Order.
  9. Extra Cost Per Item - When adding new inventory to the variant, enter the cost of freight and/or other secondary costs per item in this area. It will be calculated into your profit margins and total cost for the item on the sales and inventory reports. This amount is calculated and added for you whenever entering inventory via Receiving Order.
  10. Receive Date - When adding new inventory to the variant, this area is populated automatically with today's date, but you can click to change it to whatever you need.
  11. Vendor Consignment - If you have the Vendor Consignment feature active and if the item is a vendor consignment item, you can check this box and it will properly register as a vendor consignment sale.
  12. Add New Inventory Button - Once you have entered the quantity and cost information for your new inventory, click the Add button to add it to the line item.
  13. Current Inventory - This table shows every 'batch' of inventory received / added for this variant in chronological order. The system will use the FIFO method of inventory management, First-In-First-Out, meaning it will always sell the oldest inventory first. Costs will be used from the specific 'batch' where inventory is sold for your reporting. Each line item lists the Remaining Quantity (current on-hand amount), Total Quantity (starting quantity; this number does not change), Cost and Extra Cost Per Item, the Receive Date for the inventory, and the Type (standard inventory is a - and the other types include Consignment, Vendor Consignment, and Memo).
  14. Edit Inventory - If any of your inventory numbers were entered incorrectly, you can click the Edit button to manually make changes.
  15. Inventory History - All events in the system that adjust inventory quantities will be listed here. This includes sales, merchandise returns, and manual adjustments. This information can also be found on your Inventory History report.

 

Explore Version 3.0 of the Product Page:

Overview

Images

Variants

Serialized Items

Product Information Tab

Inventory Tab

Website Settings Tab

Advanced Settings Tab

Notes Tab


 

}', 22='{type=option, value={id=2, name='recommended_extra', order=1, label='Recommended Extra'}}', 23='{type=list, value=[{id=1, name='featured_content', order=0, label='Featured Content'}]}', 8='{type=string, value=

Setting Up Variants in a Product

If you are working with a product that will have variants of different sizes, colors, and/or styles, it is critically important to set the product to have Variants before you save it for the first time. You can do this by switching on the Variant toggle in the upper right, as pictured below.

For your core product details for variants including identifier codes such as SKUs, pricing, and images, you will work on the Product Information tab.

Please Note: You MUST set the Variant toggle before saving the product for the first time or the option will no longer be available for that product. We have set it up this way because when we allowed it to be changed after saving previously, it was making bad data and causing problems.

  1. Variant Toggle - Be sure to turn this on before you save the product for the first time. If you forget, you cannot change it later and will have to delete and recreate the product. 
  2. Variant Group Name - This will be major divisions of your variants such as Size, Color, Style, etc. You can have multiple variant groups if needed, but it's recommended not to create more than three.
  3. Variant Options - You can add as many variants as needed, and in this version of the Product page there is no need for side-scrolling, so you'll be able to see all variant options you create in a stack, as pictured below. You can drag and drop your variant options into whatever order you need them to appear.
  4. Save Variant - The Save button doesn't save the whole product, but does save whatever variant group you have created. It is necessary to save it in this way in order for the Variant Image area to show up. It is also necessary to save here before saving the product at the bottom of the page.
  5. Variant Groupings - You can click to expand or collapse any variant group you have created. Only one can be open at a time.
  6. Add a Variant - This will add a new variant group to the product.
  7. Edit - Once you have saved a variant group, you can click this button to Edit anything about it. It can be renamed or removed if you don't need it. When editing a variant, you will also see any variant options you've created, and you can edit their names or delete them as needed.

 

Adding Variant Product Details

For each of your variants you are able to enter core information such as identifier codes, weight, dimensions, condition, and finish / color, as indicated below:

  1. Location - If you have multiple store locations, they will be listed here, and you can add the data detailed below and have it apply to just the current specified location or to all of them.

  2. Search - If you're working with a lot of variants / combinations, you can search them here by entering keywords and clicking the search button.

  3. Variants - For each variant group in the product, you'll have a tab in this area. You can either work within the group, which will change the view to group all variant options under that group as pictured below, or work with All at once and see a master list of all variants.

  4. Print Label - If you click this button at the top, it will load a label line item for every variant in the product, as pictured below. If you are viewing a specific variant, it will also have this button, and it will load only that variant for print. All line items will default to print one label, but you can set whatever quantities you need.

  5. View Options - This function controls what optional data you want to see. Options include Show Items with 0 Inventory, which is on by default, and Show Deactivated Items. Set these the way you want, and then click Done.

  6. Open / Close Variant Option - Clicking this arrow will expand the variant option so you can enter data for it. When this is open, you are able to add a Variant image on the right. If all variant options are closed, that area does not display and you can only have one open at a time.

  7. Product Identifier Codes - These include UPC, Manufacturer Number, and SKU. If you have created the product from the Catalog and if that catalog works with variant data, the available identifier codes will already appear here. Even without the catalog, the system will populate a unique SKU for each variant you create, and you can either use the pre-generated SKUs or you can change it to whatever is needed. Any time you click on one of these codes, if you have multiple locations, you will have the option to Apply to All Store Locations.

  8. Alternate Barcode Title - By default, when you print a barcode label, the title for the barcode itself will be the Product Title Plus Variant Name, but if you want to display something different on the label for the product you can enter an Alternate Barcode Title here and the system will use that when printing the label for the variant.

  9. Alternate Lookups - If you have alternative names for a variant that you use internally, you can enter those terms here and when searching for the items anywhere in the system, e.g. Register, Products page, etc., the item will come up in searches using those terms.

  10. Product Weight & Dimensions - You can enter weight and dimension values for your variant in this area. These will use your store default measurement system, which will either decimal values of pounds or kilograms for Weight, inches or centimeters for Height, Width, and Length. The values you enter here for weight will work with system weight-based shipping methods. The values you enter for weight and dimensions will work for our integrations with Shipstation, Reverb, and Shopify.

  11. Condition - If you have non-serialized Conditions enabled (under Settings > Website Settings > Products) you can select the Condition of the variant here. Conditions include Brand New, Like New, Mint, Excellent, Very Good, Good, Used, Fair, Poor, Non-Functioning, and Floor Model.

  12. Finish / Color - If the item has a special Finish, e.g. glossy or matte, or a particular Color, you can enter a brief description here of those features.

  13. Variant Media - Whenever you have expanded the detail area of a variant, the Variant Media area will be visible. You can upload an image file here to represent the variant. Only one image per variant is allowed. Recommended formats are JPG, PNG, and WebP. Images that are 2k pixels wide are recommended, with a file size less than 4mb. If you want an animated image, you can use a GIF file as long as it's less than 4mb. Please see the post about Images for further details on best practices for the images you upload.

 

Adding Variant Product Pricing

Please note that for all values entered in this area, you have the option of applying each to all Store Locations, all Variants, or All Variants and Locations, which can save you a lot of data entry time.

In the Pricing area, you are able to add unique values for the variant you are editing for the following price fields:

  1. Price - The standard selling price for the item.
  2. Sale Price - If the item is part of a Scheduled Sale, or if you want to enter a price discounted from the regular Price, you can do so here.
  3. MAP Price - If the maker of the product lists a Minimum Advertised Price you need to respect, entering that price here will help you make sure your pricing does not go below MAP if you run a sale or do a bulk price edit. Doing any bulk activity or trying to save a price lower than MAP Price here will pop up a warning letting you know so you can avoid violating price agreements with your manufacturers. PLEASE NOTE: This feature is available only in version 3.0 of the Product Page or later.
  4. Website Price - If you have pricing you use on your website that is different from in-store pricing, this optional field allows you to list your standard price for web sales for the variant. If you do not use this field, the regular Price field will be used for both in-store and website sales.
  5. Website Sale Price - Again, if you use pricing that is different on your website from in-store prices, this field will allow you to list a discounted sale price from your Website Price for online sales only. If you don't use this field, the regular Sale Price field will be used for both in-store and website sales.
  6. Reverb Price - If you use the Reverb integration, you can list the price the system will use on Reverb for the item here, and it can be different from any of the above prices.
  7. Shopify Price - Shopify doesn't need dedicated pricing fields. If you use the Shopify integration, it will use whatever active pricing you have set. So if you only list a Price and Sale Price, those will display on your Shopify site. If you use Website Price and Website Sale Price, whatever is active for the product will display on Shopify.

 

Adding Variant Purchasing Information

For each Vendor you have added to the product, you will be able to set the Purchasing information listed below:

  1. Vendor Name - Each Vendor you have listed for the product (which is set in the upper section of the Product Information tab) will be listed here, with the Primary Vendor at the top. If you need to change your Primary Vendor, you can do so a the top of the page.
  2. Vendor Part Number - If the vendor has a specific part number they use, you can save that here and it will appear in relevant areas of the system such as the Inventory and Low Inventory reports, and on your Purchase Orders and Receiving Orders for the item.
  3. Packaging Quantity - If the vendor always sends the item packaged a specific way, you can list the quantity in that packaging here.
  4. Packaging Unit Type - If the item's Unit Type is relevant, you can list it as being a number of Items, Inches, Feet, Yards, or Meters.
  5. Packaging Container Type - If the package container is a Case, Bolt, Box, Roll, or Pack, you can specify that here.
  6. Apply To - All specific vendor data for the variant can be applied to all Store Locations, Variants, or to all Variants and Locations to save you data entry time.
  7. Default Cost - This value will apply to the variant and will be used when doing a new Purchase Order for the item. Please note, this value is NOT used in reporting. The actual Cost you enter for each time you receive or add inventory to the variant will be listed on the Inventory tab for the item and the reporting will use that cost to determine your inventory value and profit margins.
  8. Reorder Point - If you want this product to be included in our automated reordering recommendations, you will want to set the Reorder Point value. When the product's inventory gets down to this value, it will appear on the Low Inventory report or in the Low Inventory view of the main Inventory report. It will also display in the Purchase Queue when doing a Purchase Order for any of the Vendors saved for the product.
  9. Desired Stock Level - Again, if you are wanting this product to be included in our automated reordering recommendations, you can set a Desired Stock Level. When adding the item to a Purchase Order or Receiving Order, the system will make sure the quantity being ordered will result in an inventory level that is at or above the number entered here. For example, If the product pictured above is down to 1 item in stock and it's added to a Purchase Order, the system will recommend ordering a case of 8 items, which will bring the stock level to 9.

 

Adding Inventory to Your Variants

On the Inventory tab for the product, each of your variants will have an area for entering inventory quantities and costs and for tracking inventory history events, as detailed below.

  1. Inventory Tab - To work with the variant quantities and cost, click on the product's Inventory tab.
  2. Location - You will work with specific inventory quantities and costs for a single location at a time if you have multiple locations saved in the system. You can easily switch between locations using these tabs at the top.
  3. Search Variants - Each variant you have saved for the product will be listed below and you can search and jump to the one you want from here.
  4. View Options - You have some view options for this area that allow you to Show Items with Zero Inventory and Show Deactivated Items. By default, you won't see deactivated variants and you will see items with zero inventory.
  5. Variant Inventory Expand / Collapse - Click here to expand or collapse the full Inventory info area for the variant. Only one variant can be open at once.
  6. Active Location - The location you are working with will be highlighted here, you can change to a different location using the tabs at the top.
  7. Add New Inventory Quantity - If you wish to manually add inventory quantity to the variant at the active location, enter the quantity here. For items that sell by the yard or meter, this can be entered as a decimal value for fractional yardage / meterage.
  8. Cost Per Item - When adding new inventory to the variant, enter your base cost for the item here. The cost should be entered for a full yard or meter for items sold that way. This amount is calculated and added for you whenever entering inventory via Receiving Order.
  9. Extra Cost Per Item - When adding new inventory to the variant, enter the cost of freight and/or other secondary costs per item in this area. It will be calculated into your profit margins and total cost for the item on the sales and inventory reports. This amount is calculated and added for you whenever entering inventory via Receiving Order.
  10. Receive Date - When adding new inventory to the variant, this area is populated automatically with today's date, but you can click to change it to whatever you need.
  11. Vendor Consignment - If you have the Vendor Consignment feature active and if the item is a vendor consignment item, you can check this box and it will properly register as a vendor consignment sale.
  12. Add New Inventory Button - Once you have entered the quantity and cost information for your new inventory, click the Add button to add it to the line item.
  13. Current Inventory - This table shows every 'batch' of inventory received / added for this variant in chronological order. The system will use the FIFO method of inventory management, First-In-First-Out, meaning it will always sell the oldest inventory first. Costs will be used from the specific 'batch' where inventory is sold for your reporting. Each line item lists the Remaining Quantity (current on-hand amount), Total Quantity (starting quantity; this number does not change), Cost and Extra Cost Per Item, the Receive Date for the inventory, and the Type (standard inventory is a - and the other types include Consignment, Vendor Consignment, and Memo).
  14. Edit Inventory - If any of your inventory numbers were entered incorrectly, you can click the Edit button to manually make changes.
  15. Inventory History - All events in the system that adjust inventory quantities will be listed here. This includes sales, merchandise returns, and manual adjustments. This information can also be found on your Inventory History report.

 

Explore Version 3.0 of the Product Page:

Overview

Images

Variants

Serialized Items

Product Information Tab

Inventory Tab

Website Settings Tab

Advanced Settings Tab

Notes Tab

Reverb Tab

 

 

}', 9='{type=string, value=Product Page 3.0: Part 3 - Variants}', 25='{type=number, value=0}', 26='{type=list, value=[{id=190209692537, name='Inventory'}]}', 28='{type=string, value=Product Page 3.0: Part 3 - Variants Setting Up Variants in a Product If you are working with a product that will have variants of different sizes, colors, and/or styles, it is critically important to set the product to have Variants before you save it for the first time. You can do this by switching on the Variant toggle in the upper right, as pictured below. For your core product details for variants including identifier codes such as SKUs, pricing, and images, you will work on the Product Information tab. Please Note: You MUST set the Variant toggle before saving the product for the first time or the option will no longer be available for that product. We have set it up this way because when we allowed it to be changed after saving previously, it was making bad data and causing problems. Variant Toggle - Be sure to turn this on before you save the product for the first time. If you forget, you cannot change it later and will have to delete and recreate the product. Variant Group Name - This will be major divisions of your variants such as Size, Color, Style, etc. You can have multiple variant groups if needed, but it's recommended not to create more than three. Variant Options - You can add as many variants as needed, and in this version of the Product page there is no need for side-scrolling, so you'll be able to see all variant options you create in a stack, as pictured below. You can drag and drop your variant options into whatever order you need them to appear. Save Variant - The Save button doesn't save the whole product, but does save whatever variant group you have created. It is necessary to save it in this way in order for the Variant Image area to show up. It is also necessary to save here before saving the product at the bottom of the page. Variant Groupings - You can click to expand or collapse any variant group you have created. Only one can be open at a time. Add a Variant - This will add a new variant group to the product. Edit - Once you have saved a variant group, you can click this button to Edit anything about it. It can be renamed or removed if you don't need it. When editing a variant, you will also see any variant options you've created, and you can edit their names or delete them as needed. Adding Variant Product Details For each of your variants you are able to enter core information such as identifier codes, weight, dimensions, condition, and finish / color, as indicated below: Location - If you have multiple store locations, they will be listed here, and you can add the data detailed below and have it apply to just the current specified location or to all of them. Search - If you're working with a lot of variants / combinations, you can search them here by entering keywords and clicking the search button. Variants - For each variant group in the product, you'll have a tab in this area. You can either work within the group, which will change the view to group all variant options under that group as pictured below, or work with All at once and see a master list of all variants. Print Label - If you click this button at the top, it will load a label line item for every variant in the product, as pictured below. If you are viewing a specific variant, it will also have this button, and it will load only that variant for print. All line items will default to print one label, but you can set whatever quantities you need. View Options - This function controls what optional data you want to see. Options include Show Items with 0 Inventory, which is on by default, and Show Deactivated Items. Set these the way you want, and then click Done. Open / Close Variant Option - Clicking this arrow will expand the variant option so you can enter data for it. When this is open, you are able to add a Variant image on the right. If all variant options are closed, that area does not display and you can only have one open at a time. Product Identifier Codes - These include UPC, Manufacturer Number, and SKU. If you have created the product from the Catalog and if that catalog works with variant data, the available identifier codes will already appear here. Even without the catalog, the system will populate a unique SKU for each variant you create, and you can either use the pre-generated SKUs or you can change it to whatever is needed. Any time you click on one of these codes, if you have multiple locations, you will have the option to Apply to All Store Locations. Alternate Barcode Title - By default, when you print a barcode label, the title for the barcode itself will be the Product Title Plus Variant Name, but if you want to display something different on the label for the product you can enter an Alternate Barcode Title here and the system will use that when printing the label for the variant. Alternate Lookups - If you have alternative names for a variant that you use internally, you can enter those terms here and when searching for the items anywhere in the system, e.g. Register, Products page, etc., the item will come up in searches using those terms. Product Weight & Dimensions - You can enter weight and dimension values for your variant in this area. These will use your store default measurement system, which will either decimal values of pounds or kilograms for Weight, inches or centimeters for Height, Width, and Length. The values you enter here for weight will work with system weight-based shipping methods. The values you enter for weight and dimensions will work for our integrations with Shipstation, Reverb, and Shopify. Condition - If you have non-serialized Conditions enabled (under Settings > Website Settings > Products) you can select the Condition of the variant here. Conditions include Brand New, Like New, Mint, Excellent, Very Good, Good, Used, Fair, Poor, Non-Functioning, and Floor Model. Finish / Color - If the item has a special Finish, e.g. glossy or matte, or a particular Color, you can enter a brief description here of those features. Variant Media - Whenever you have expanded the detail area of a variant, the Variant Media area will be visible. You can upload an image file here to represent the variant. Only one image per variant is allowed. Recommended formats are JPG, PNG, and WebP. Images that are 2k pixels wide are recommended, with a file size less than 4mb. If you want an animated image, you can use a GIF file as long as it's less than 4mb. Please see the post about Images for further details on best practices for the images you upload. Adding Variant Product Pricing Please note that for all values entered in this area, you have the option of applying each to all Store Locations, all Variants, or All Variants and Locations, which can save you a lot of data entry time. In the Pricing area, you are able to add unique values for the variant you are editing for the following price fields: Price - The standard selling price for the item. Sale Price - If the item is part of a Scheduled Sale, or if you want to enter a price discounted from the regular Price, you can do so here. MAP Price - If the maker of the product lists a Minimum Advertised Price you need to respect, entering that price here will help you make sure your pricing does not go below MAP if you run a sale or do a bulk price edit. Doing any bulk activity or trying to save a price lower than MAP Price here will pop up a warning letting you know so you can avoid violating price agreements with your manufacturers. PLEASE NOTE: This feature is available only in version 3.0 of the Product Page or later. Website Price - If you have pricing you use on your website that is different from in-store pricing, this optional field allows you to list your standard price for web sales for the variant. If you do not use this field, the regular Price field will be used for both in-store and website sales. Website Sale Price - Again, if you use pricing that is different on your website from in-store prices, this field will allow you to list a discounted sale price from your Website Price for online sales only. If you don't use this field, the regular Sale Price field will be used for both in-store and website sales. Reverb Price - If you use the Reverb integration, you can list the price the system will use on Reverb for the item here, and it can be different from any of the above prices. Shopify Price - Shopify doesn't need dedicated pricing fields. If you use the Shopify integration, it will use whatever active pricing you have set. So if you only list a Price and Sale Price, those will display on your Shopify site. If you use Website Price and Website Sale Price, whatever is active for the product will display on Shopify. Adding Variant Purchasing Information For each Vendor you have added to the product, you will be able to set the Purchasing information listed below: Vendor Name - Each Vendor you have listed for the product (which is set in the upper section of the Product Information tab) will be listed here, with the Primary Vendor at the top. If you need to change your Primary Vendor, you can do so a the top of the page. Vendor Part Number - If the vendor has a specific part number they use, you can save that here and it will appear in relevant areas of the system such as the Inventory and Low Inventory reports, and on your Purchase Orders and Receiving Orders for the item. Packaging Quantity - If the vendor always sends the item packaged a specific way, you can list the quantity in that packaging here. Packaging Unit Type - If the item's Unit Type is relevant, you can list it as being a number of Items, Inches, Feet, Yards, or Meters. Packaging Container Type - If the package container is a Case, Bolt, Box, Roll, or Pack, you can specify that here. Apply To - All specific vendor data for the variant can be applied to all Store Locations, Variants, or to all Variants and Locations to save you data entry time. Default Cost - This value will apply to the variant and will be used when doing a new Purchase Order for the item. Please note, this value is NOT used in reporting. The actual Cost you enter for each time you receive or add inventory to the variant will be listed on the Inventory tab for the item and the reporting will use that cost to determine your inventory value and profit margins. Reorder Point - If you want this product to be included in our automated reordering recommendations, you will want to set the Reorder Point value. When the product's inventory gets down to this value, it will appear on the Low Inventory report or in the Low Inventory view of the main Inventory report. It will also display in the Purchase Queue when doing a Purchase Order for any of the Vendors saved for the product. Desired Stock Level - Again, if you are wanting this product to be included in our automated reordering recommendations, you can set a Desired Stock Level. When adding the item to a Purchase Order or Receiving Order, the system will make sure the quantity being ordered will result in an inventory level that is at or above the number entered here. For example, If the product pictured above is down to 1 item in stock and it's added to a Purchase Order, the system will recommend ordering a case of 8 items, which will bring the stock level to 9. Adding Inventory to Your Variants On the Inventory tab for the product, each of your variants will have an area for entering inventory quantities and costs and for tracking inventory history events, as detailed below. Inventory Tab - To work with the variant quantities and cost, click on the product's Inventory tab. Location - You will work with specific inventory quantities and costs for a single location at a time if you have multiple locations saved in the system. You can easily switch between locations using these tabs at the top. Search Variants - Each variant you have saved for the product will be listed below and you can search and jump to the one you want from here. View Options - You have some view options for this area that allow you to Show Items with Zero Inventory and Show Deactivated Items. By default, you won't see deactivated variants and you will see items with zero inventory. Variant Inventory Expand / Collapse - Click here to expand or collapse the full Inventory info area for the variant. Only one variant can be open at once. Active Location - The location you are working with will be highlighted here, you can change to a different location using the tabs at the top. Add New Inventory Quantity - If you wish to manually add inventory quantity to the variant at the active location, enter the quantity here. For items that sell by the yard or meter, this can be entered as a decimal value for fractional yardage / meterage. Cost Per Item - When adding new inventory to the variant, enter your base cost for the item here. The cost should be entered for a full yard or meter for items sold that way. This amount is calculated and added for you whenever entering inventory via Receiving Order. Extra Cost Per Item - When adding new inventory to the variant, enter the cost of freight and/or other secondary costs per item in this area. It will be calculated into your profit margins and total cost for the item on the sales and inventory reports. This amount is calculated and added for you whenever entering inventory via Receiving Order. Receive Date - When adding new inventory to the variant, this area is populated automatically with today's date, but you can click to change it to whatever you need. Vendor Consignment - If you have the Vendor Consignment feature active and if the item is a vendor consignment item, you can check this box and it will properly register as a vendor consignment sale. Add New Inventory Button - Once you have entered the quantity and cost information for your new inventory, click the Add button to add it to the line item. Current Inventory - This table shows every 'batch' of inventory received / added for this variant in chronological order. The system will use the FIFO method of inventory management, First-In-First-Out, meaning it will always sell the oldest inventory first. Costs will be used from the specific 'batch' where inventory is sold for your reporting. Each line item lists the Remaining Quantity (current on-hand amount), Total Quantity (starting quantity; this number does not change), Cost and Extra Cost Per Item, the Receive Date for the inventory, and the Type (standard inventory is a - and the other types include Consignment, Vendor Consignment, and Memo). Edit Inventory - If any of your inventory numbers were entered incorrectly, you can click the Edit button to manually make changes. Inventory History - All events in the system that adjust inventory quantities will be listed here. This includes sales, merchandise returns, and manual adjustments. This information can also be found on your Inventory History report. Explore Version 3.0 of the Product Page: Overview Images Variants Serialized Items Product Information Tab Inventory Tab Website Settings Tab Advanced Settings Tab Notes Tab Inventory add edit product page}'}, {id=191604258922, createdAt=1750439292855, updatedAt=1753712801757, path='product-page-3-0-part-5-product-information-tab', name='Product Page 3.0: Part 5 - Product Information Tab', 16='{type=list, value=[{id=4, name='music_shop_360', order=3, label='Music Shop 360'}]}', 2='{type=string, value=https://rainpos.my.site.com/s/article/Product-Page-3-0-Part-5-Product-Information-Tab}', 4='{type=list, value=[{id=1, name='rain_pos', order=0, label='Rain POS'}, {id=2, name='like_sew', order=1, label='Like Sew'}, {id=3, name='jewel360', order=2, label='Jewel360'}]}', 21='{type=number, value=0}', 6='{type=string, value=

The primary details about your product will be in the Product Information tab.

 

Product Information

At the top of the Product Information tab you are able to work with the following areas:

  1. Product Page Tabs - The Product Information tab loads by default when creating a new product, and you can switch freely between tabs without needing to save.

  2. Serialized and Variant Settings - Be sure to toggle whichever of these might apply to your new product to On before saving your product for the first time, or you will not be able to do so later.

  3. Catalog Search - Our Catalog contains many products across many industries. You can search by keyword or product identifier (UPC / Manufacturer Number) and if you find a match, clicking on the result in the catalog will load basic data, images, and descriptions into your product.

  4. Product Title - Enter a complete Title for the product here, using an exact match to what the manufacturer uses is recommended so searches will match with higher reliability for your customers.

  5. Department - If you use Departments, click on the one appropriate for this product in the drop-list. A product can have only one Department.

  6. Availability - By default, new products will be available on both your Website and in your Point of Sale, but you can change it to one or the other if needed.

  7. Manufacturer - Click on the appropriate Manufacturer in the drop-list if it has already been entered. Clicking will also allow you to search for a match.

  8. Add / Edit / Remove Manufacturer - Clicking the edit button will pop up a window that will allow you to search for existing Manufacturers on your list and either edit or delete them, if needed. You can also enter new ones from here.

  9. Vendor - Clicking this field will allow you to select as many Vendors from your list as you need for this product.

  10. Select Primary Vendor - If you choose more than one, you can select whichever one will be your Primary Vendor for the item. The Primary vendor will be the one that displays by default for the item and will come up in vendor item searches when creating a new Purchase Order. In addition, the Low Inventory report and the Low Inventory view of the Inventory report will display the Primary Vendor of the item if it's inventory is at or below its Reorder Point (see the section below on Purchasing).

  11. Make - You can list the name of the maker brand here, and this can be different than the base Manufacturer if needed.

  12. Model - Enter the model name of the item here.

  13. Year - Enter the year of the model here.

  14. Taxes - By default, the item will use your primary physical product tax rate, which in the system is labeled as your Materials tax. If it needs to use a different rate or if the item is not taxable and needs no rate at all, you can click the drop-list and check / uncheck whatever boxes are necessary.

  15. Upload Media - As mentioned above, this area is actually visible from all tabs of the product and you can add images or animated media (GIF files) if you like at any point in your product creation process. You can drag and drop multiple files at once and all will load simultaneously. Once loaded, you can drag and drop the thumbnails into whatever order you need. Please see the article linked below on Images if you want further details on creating the best product shopping experience for your customers in this area.

 

Product Details

This area allows you to enter important information about the item. Here are the data points you can set in this section:

  1. Store Location - If you have multiple store locations in the system, you will see each of them in this area, either as they appear above or in a drop-list. As you enter data for the item, it will apply to the selected Location, but most data points here can be applied to all of your locations. As you're entering information, you'll see a link to Apply to All Locations, which will save you data entry time.
  2. Print Label - If you click this button at the top, it will load a label line item for every variant in the product, if it has variants as pictured below. All line items will default to print one label, but you can set whatever quantities you need.
  3. UPC - If the product has a Universal Product Code that is officially registered with the UPC organization, you can list it here. Codes of this type are always numbers only, and is a 12-digit identifier. It is also known as a GTIN (Global Trade Identifier Number) since it is used globally. Entering a code that is not registered can result in failed searches for the item, so it is recommended to enter only actual UPC codes for your items.
  4. Manufacturer Number - If the manufacturer for the item has an identifier code they use you can enter it here for reference and searches. You can enter alphanumeric characters and common punctuations and symbols if needed.
  5. SKU - By default, a unique SKU will appear here with each new product you create. You can adjust this to whatever you need, using alphanumeric characters as well as common punctuations and symbols.
  6. Alternate Barcode Title - By default, when you print a barcode label, the title for the barcode itself will be the Product Title Plus any Variant Name, but if you want to display something different on the label for the product you can enter an Alternate Barcode Title here and the system will use that when printing the label for the product.
  7. Alternate Lookups - If you have alternative names for a variant that you use internally, you can enter those terms here and when searching for the items anywhere in the system, e.g. Register, Products page, etc., the item will come up in searches using those terms.
  8. Add Alternate Lookup Row - If you need more Alternate Lookups you can click this button and add as many as you like.
  9. Weight - You can enter weight values for your items here. This will use your store default measurement system, which will either decimal values of pounds or kilograms for Weight. The values you enter here for weight will work with system weight-based shipping methods. The values you enter for weight will work for our integrations with ShipstationReverb, and Shopify.
  10. Product Dimensions - You can also enter dimension values for your item this area. These will use your store default measurement system, which will either be inches or centimeters for HeightWidth, and Length. The values you enter for dimensions will also work for our integrations with ShipstationReverb, and Shopify.
  11. Condition - If you have non-serialized Conditions enabled (under Settings > Website Settings > Products) you can select the Condition of the item here. Conditions include Brand NewLike NewMintExcellentVery GoodGoodUsedFairPoorNon-Functioning, and Floor Model.
  12. Finish / Color - If the item has a special Finish, e.g. glossy or matte, or a particular Color, you can enter a brief description here of those features.

 

Pricing

In this section, you can enter price values for all prices you have enabled in the system for your items.

  1. Price - Enter your normal selling Price for the item here. If you do not use Website Price fields, this price will be used for your sales online and in-store.
  2. Sale Price - If you sell the item at a discounted price, you can enter that manually here. Transactions in the Register will show the original Price and your Sale Price so customers will know how much you love them. Online, if you're not using the website price fields, the Price will be crossed out and the Sale Price will display. Useful tools such as the Scheduled Sale tool under the Marketing menu allow you to schedule sale prices to be put into products and removed again when the sale is finished.
  3. MAP Price - If you have manufacturers that require you to respect MAP Price (minimum advertised price) you can enter that value here and the system will warn you whenever you try to save a price for the item that would be below your MAP guideline.
  4. Website Price - If you need to have different pricing in-store and online, you can use the Website Price to enter the standard price for the item that will appear online. If you don't see this field and want to use website pricing, you can enable it under Settings > Features > Website Pricing.
  5. Website Sale Price - If you want to sell online at a discount you can either enter a Website Sale Price here manually or schedule the pricing to be saved here automatically using the Scheduled Sale tool, which will also remove the online sale price after your sale is over. When a price is in this field, the regular Website Price will display crossed out, and the website sale price will be active.
  6. Reverb Price - If you are integrated with Reverb and if the item is synced to your Reverb online store, you can enter the selling price for it here.
  7. Wholesale Price (Not Pictured) - If you use our online Wholesale selling system, you can list the Wholesale Price for  your item here. Only customers with active wholesale login credentials will be able to see this pricing.

 

Purchasing

If this is a product  you plan to re-order in the future, you can enter purchasing information here that will be used by our Purchase Order / Receiving Order system.

  1. Vendor Name - Each of the Vendors you have set for the product will appear here, and whichever is the Primary Vendor will be indicated.
  2. Vendor Part Number - If the vendor has a part number they need to see on purchase orders, you can enter that part number here. These codes can use alphanumeric characters and common symbols and punctuation and will be visible on the PO as well as in the Low Inventory report and the Inventory report's low inventory view.
  3. Packaging - If the item has consistent packaging used by the vendor, you can enter that here so the system will order it according to the specifications. Enter how many of the items are in each container, the item type in the second dropdown (if the item is individual Items, or if it's sold by Inches, Feet, Yards, or Meters), and the packaging type in the final dropdown (if it's sold by the Case, Bolt, Box, Roll, or Pack).
  4. Apply to All Store Locations - If you will use the same Vendor information for your purchasing from all of your store locations, you can click this link to apply what you've entered across all your stores.
  5. Default Cost - This is what you expect your cost to be the next time you order the item. This field updates automatically based on the last Receiving Order cost for the item. Please note that for each shipment you receive for the item a unique Cost will be saved and tracked for your reporting so your profit margins will be accurate historically. Your Default Cost is not used in the reports.
  6. Reorder Point - If you want this product to be included in our automated reordering recommendations, you will want to set the Reorder Point value. When the product's inventory gets down to this value, it will appear on the Low Inventory report or in the Low Inventory view of the main Inventory report. It will also display in the Purchase Queue when doing a Purchase Order for any of the Vendors saved for the product.
  7. Desired Stock Level - Again, if you are wanting this product to be included in our automated reordering recommendations, you can set a Desired Stock Level. When adding the item to a Purchase Order or Receiving Order, the system will make sure the quantity being ordered will result in an inventory level that is at or above the number entered here. For example, If the product pictured above is down to 1 item in stock and it's added to a Purchase Order, the system will recommend ordering a case of 6 items, which will bring the stock level to 7.

 

Deactivating and Saving

At the bottom of every tab, you'll have the saving and closing options detailed below, but only on the Product Information tab will you see your options for deactivating the item. Here is what you can do with those functions:

  1. Deactivate Item for This Location - If you don't need to have the item active at the specific Location you are currently viewing, you can Deactivate it with this toggle. It will still be active for your other locations. Deactivated items do not display online, in searches in your system, or in the Register.
  2. Deactivate Product - This toggle will Deactivate the product for all of your store locations. Deactivating is like a light version of deleting the product and is useful for temporarily making a product inactive until you are able to reorder it and get it back in stock. It will not display online, will not come up in any system searches for you, and will not be available in the Register. You can find your deactivated items from Inventory > Products by clicking Filters and in the Product Status area, selecting Deactivated. Please note, if the product has multiple variants, this function deactivates all of them for all locations.
  3. Save Product - Clicking this will save whatever changes you might have made in the item, but will keep the product window open in case you need to continue working.
  4. Save Actions - If you are done making changes in the item, the default Save & Close button will save those updates and then close the window, taking you to the main Products list page. If you click the down arrow, you can see the option to Save & Duplicate, which will save the current product and copy everything except identifiers and images into a new product that will open for you as a copy. In the dropdown you also have the option to Save & New, which will save the current product and open a new blank one for you to start on.

  1. Delete - Our system uses what is known as a 'soft-delete', and that means if you decide to delete the item and later need it back, you can reactivate it. Deleting a product is good if it's sold out and you're sure you won't be reordering it again, and removes it from searches in the system, from the website, and from the Register. If you need to find it again, you can go to Inventory > Products, click the Filters button in the upper right, go to Product Status, and filter for Deleted items. Reopen the item from there and you can activate it again at the bottom.
  2. Close - Clicking to Close the product will close the window. If you have unsaved changes, you will be reminded to save them just in case.

* Example images, the BigMe logo, and Bigme InkNote Color+ Kaleido3 are copyright BigMe and are used here for not-for-profit demonstration purposes only.

 

Explore Version 3.0 of the Product Page:

Overview

Images

Variants

Serialized Items

Product Information Tab

Inventory Tab

Website Settings Tab

Advanced Settings Tab

Notes Tab

 

 

}', 22='{type=option, value={id=2, name='recommended_extra', order=1, label='Recommended Extra'}}', 23='{type=list, value=[{id=1, name='featured_content', order=0, label='Featured Content'}]}', 8='{type=string, value=

The primary details about your product will be in the Product Information tab.

 

Product Information

At the top of the Product Information tab you are able to work with the following areas:

  1. Product Page Tabs - The Product Information tab loads by default when creating a new product, and you can switch freely between tabs without needing to save.

  2. Serialized and Variant Settings - Be sure to toggle whichever of these might apply to your new product to On before saving your product for the first time, or you will not be able to do so later.

  3. Catalog Search - Our Catalog contains many products across many industries. You can search by keyword or product identifier (UPC / Manufacturer Number) and if you find a match, clicking on the result in the catalog will load basic data, images, and descriptions into your product.

  4. Product Title - Enter a complete Title for the product here, using an exact match to what the manufacturer uses is recommended so searches will match with higher reliability for your customers.

  5. Department- If you use Departments, click on the one appropriate for this product in the drop-list. A product can have only one Department.

  6. Availability - By default, new products will be available on both your Website and in your Point of Sale, but you can change it to one or the other if needed.

  7. Manufacturer- Click on the appropriate Manufacturer in the drop-list if it has already been entered. Clicking will also allow you to search for a match.

  8. Add / Edit / Remove Manufacturer - Clicking the edit button will pop up a window that will allow you to search for existing Manufacturers on your list and either edit or delete them, if needed. You can also enter new ones from here.

  9. Vendor - Clicking this field will allow you to select as many Vendors from your list as you need for this product.

  10. Select Primary Vendor - If you choose more than one, you can select whichever one will be your Primary Vendor for the item. The Primary vendor will be the one that displays by default for the item and will come up in vendor item searches when creating a new Purchase Order. In addition, the Low Inventory report and the Low Inventory view of the Inventory report will display the Primary Vendor of the item if it's inventory is at or below its Reorder Point (see the section below on Purchasing).

  11. Make- You can list the name of the maker brand here, and this can be different than the base Manufacturer if needed.

  12. Model- Enter the model name of the item here.

  13. Year- Enter the year of the model here.

  14. Taxes - By default, the item will use your primary physical product tax rate, which in the system is labeled as your Materials tax. If it needs to use a different rate or if the item is not taxable and needs no rate at all, you can click the drop-list and check / uncheck whatever boxes are necessary.

  15. Upload Media - As mentioned above, this area is actually visible from all tabs of the product and you can add images or animated media (GIF files) if you like at any point in your product creation process. You can drag and drop multiple files at once and all will load simultaneously. Once loaded, you can drag and drop the thumbnails into whatever order you need. Please see the article linked below on Images if you want further details on creating the best product shopping experience for your customers in this area.

 

Product Details

This area allows you to enter important information about the item. Here are the data points you can set in this section:

  1. Store Location - If you have multiple store locations in the system, you will see each of them in this area, either as they appear above or in a drop-list. As you enter data for the item, it will apply to the selected Location, but most data points here can be applied to all of your locations. As you're entering information, you'll see a link to Apply to All Locations, which will save you data entry time.
  2. Print Label - If you click this button at the top, it will load a label line item for every variant in the product, if it has variants as pictured below. All line items will default to print one label, but you can set whatever quantities you need.
  3. UPC- If the product has a Universal Product Code that is officially registered with the UPC organization, you can list it here. Codes of this type are always numbers only, and is a 12-digit identifier. It is also known as a GTIN (Global Trade Identifier Number) since it is used globally. Entering a code that is not registered can result in failed searches for the item, so it is recommended to enter only actual UPC codes for your items.
  4. Manufacturer Number - If the manufacturer for the item has an identifier code they use you can enter it here for reference and searches. You can enter alphanumeric characters and common punctuations and symbols if needed.
  5. SKU- By default, a unique SKU will appear here with each new product you create. You can adjust this to whatever you need, using alphanumeric characters as well as common punctuations and symbols.
  6. Alternate Barcode Title - By default, when you print a barcode label, the title for the barcode itself will be the Product Title Plus any Variant Name, but if you want to display something different on the label for the product you can enter an Alternate Barcode Title here and the system will use that when printing the label for the product.
  7. Alternate Lookups - If you have alternative names for a variant that you use internally, you can enter those terms here and when searching for the items anywhere in the system, e.g. Register, Products page, etc., the item will come up in searches using those terms.
  8. Add Alternate Lookup Row - If you need more Alternate Lookups you can click this button and add as many as you like.
  9. Weight- You can enter weight values for your items here. This will use your store default measurement system, which will either decimal values of pounds or kilograms for Weight. The values you enter here for weight will work with system weight-based shipping methods. The values you enter for weight will work for our integrations with ShipstationReverb, and Shopify.
  10. Product Dimensions - You can also enter dimension values for your item this area. These will use your store default measurement system, which will either be inches or centimeters for HeightWidth, and Length. The values you enter for dimensions will also work for our integrations with ShipstationReverb, and Shopify.
  11. Condition- If you have non-serialized Conditions enabled (under Settings > Website Settings > Products) you can select the Condition of the item here. Conditions include Brand NewLike NewMintExcellentVery GoodGoodUsedFairPoorNon-Functioning, and Floor Model.
  12. Finish / Color - If the item has a special Finish, e.g. glossy or matte, or a particular Color, you can enter a brief description here of those features.

 

Pricing

In this section, you can enter price values for all prices you have enabled in the system for your items.

  1. Price- Enter your normal selling Price for the item here. If you do not use Website Price fields, this price will be used for your sales online and in-store.
  2. Sale Price - If you sell the item at a discounted price, you can enter that manually here. Transactions in the Register will show the original Price and your Sale Price so customers will know how much you love them. Online, if you're not using the website price fields, the Price will be crossed out and the Sale Price will display. Useful tools such as the Scheduled Sale tool under the Marketing menu allow you to schedule sale prices to be put into products and removed again when the sale is finished.
  3. MAP Price - If you have manufacturers that require you to respect MAP Price (minimum advertised price) you can enter that value here and the system will warn you whenever you try to save a price for the item that would be below your MAP guideline.
  4. Website Price - If you need to have different pricing in-store and online, you can use the Website Price to enter the standard price for the item that will appear online. If you don't see this field and want to use website pricing, you can enable it under Settings > Features > Website Pricing.
  5. Website Sale Price - If you want to sell online at a discount you can either enter a Website Sale Price here manually or schedule the pricing to be saved here automatically using the Scheduled Sale tool, which will also remove the online sale price after your sale is over. When a price is in this field, the regular Website Price will display crossed out, and the website sale price will be active.
  6. Reverb Price - If you are integrated with Reverb and if the item is synced to your Reverb online store, you can enter the selling price for it here.
  7. Wholesale Price (Not Pictured) - If you use our online Wholesale selling system, you can list the Wholesale Price for  your item here. Only customers with active wholesale login credentials will be able to see this pricing.

 

Purchasing

If this is a product  you plan to re-order in the future, you can enter purchasing information here that will be used by our Purchase Order / Receiving Order system.

  1. Vendor Name - Each of the Vendors you have set for the product will appear here, and whichever is the Primary Vendor will be indicated.
  2. Vendor Part Number - If the vendor has a part number they need to see on purchase orders, you can enter that part number here. These codes can use alphanumeric characters and common symbols and punctuation and will be visible on the PO as well as in the Low Inventory report and the Inventory report's low inventory view.
  3. Packaging- If the item has consistent packaging used by the vendor, you can enter that here so the system will order it according to the specifications. Enter how many of the items are in each container, the item type in the second dropdown (if the item is individual Items, or if it's sold by Inches, Feet, Yards, or Meters), and the packaging type in the final dropdown (if it's sold by the Case, Bolt, Box, Roll, or Pack).
  4. Apply to All Store Locations - If you will use the same Vendor information for your purchasing from all of your store locations, you can click this link to apply what you've entered across all your stores.
  5. Default Cost - This is what you expect your cost to be the next time you order the item. This field updates automatically based on the last Receiving Order cost for the item. Please note that for each shipment you receive for the item a unique Cost will be saved and tracked for your reporting so your profit margins will be accurate historically. Your Default Cost is not used in the reports.
  6. Reorder Point - If you want this product to be included in our automated reordering recommendations, you will want to set the Reorder Point value. When the product's inventory gets down to this value, it will appear on the Low Inventory report or in the Low Inventory view of the main Inventory report. It will also display in the Purchase Queue when doing a Purchase Order for any of the Vendors saved for the product.
  7. Desired Stock Level - Again, if you are wanting this product to be included in our automated reordering recommendations, you can set a Desired Stock Level. When adding the item to a Purchase Order or Receiving Order, the system will make sure the quantity being ordered will result in an inventory level that is at or above the number entered here. For example, If the product pictured above is down to 1 item in stock and it's added to a Purchase Order, the system will recommend ordering a case of 6 items, which will bring the stock level to 7.

 

Deactivating and Saving

At the bottom of every tab, you'll have the saving and closing options detailed below, but only on the Product Information tab will you see your options for deactivating the item. Here is what you can do with those functions:

  1. Deactivate Item for This Location - If you don't need to have the item active at the specific Location you are currently viewing, you can Deactivate it with this toggle. It will still be active for your other locations. Deactivated items do not display online, in searches in your system, or in the Register.
  2. Deactivate Product - This toggle will Deactivate the product for all of your store locations. Deactivating is like a light version of deleting the product and is useful for temporarily making a product inactive until you are able to reorder it and get it back in stock. It will not display online, will not come up in any system searches for you, and will not be available in the Register. You can find your deactivated items from Inventory > Products by clicking Filters and in the Product Status area, selecting Deactivated. Please note, if the product has multiple variants, this function deactivates all of them for all locations.
  3. Save Product - Clicking this will save whatever changes you might have made in the item, but will keep the product window open in case you need to continue working.
  4. Save Actions - If you are done making changes in the item, the default Save & Close button will save those updates and then close the window, taking you to the main Products list page. If you click the down arrow, you can see the option to Save & Duplicate, which will save the current product and copy everything except identifiers and images into a new product that will open for you as a copy. In the dropdown you also have the option to Save & New, which will save the current product and open a new blank one for you to start on.

  1. Delete- Our system uses what is known as a 'soft-delete', and that means if you decide to delete the item and later need it back, you can reactivate it. Deleting a product is good if it's sold out and you're sure you won't be reordering it again, and removes it from searches in the system, from the website, and from the Register. If you need to find it again, you can go to Inventory > Products, click the Filters button in the upper right, go to Product Status, and filter for Deleted items. Reopen the item from there and you can activate it again at the bottom.
  2. Close- Clicking to Close the product will close the window. If you have unsaved changes, you will be reminded to save them just in case.

* Example images, the BigMe logo, and Bigme InkNote Color+ Kaleido3 are copyright BigMe and are used here for not-for-profit demonstration purposes only.

 

Explore Version 3.0 of the Product Page:

Overview

Images

Variants

Serialized Items

Product Information Tab

Inventory Tab

Website Settings Tab

Advanced Settings Tab

Notes Tab

Reverb Tab

 

 

}', 9='{type=string, value=Product Page 3.0: Part 5 - Product Information Tab}', 25='{type=number, value=0}', 26='{type=list, value=[{id=190209692537, name='Inventory'}]}', 28='{type=string, value=Product Page 3.0: Part 5 - Product Information Tab The primary details about your product will be in the Product Information tab. Product Information At the top of the Product Information tab you are able to work with the following areas: Product Page Tabs - The Product Information tab loads by default when creating a new product, and you can switch freely between tabs without needing to save. Serialized and Variant Settings - Be sure to toggle whichever of these might apply to your new product to On before saving your product for the first time, or you will not be able to do so later. Catalog Search - Our Catalog contains many products across many industries. You can search by keyword or product identifier (UPC / Manufacturer Number) and if you find a match, clicking on the result in the catalog will load basic data, images, and descriptions into your product. Product Title - Enter a complete Title for the product here, using an exact match to what the manufacturer uses is recommended so searches will match with higher reliability for your customers. Department- If you use Departments, click on the one appropriate for this product in the drop-list. A product can have only one Department. Availability - By default, new products will be available on both your Website and in your Point of Sale, but you can change it to one or the other if needed. Manufacturer- Click on the appropriate Manufacturer in the drop-list if it has already been entered. Clicking will also allow you to search for a match. Add / Edit / Remove Manufacturer - Clicking the edit button will pop up a window that will allow you to search for existing Manufacturers on your list and either edit or delete them, if needed. You can also enter new ones from here. Vendor - Clicking this field will allow you to select as many Vendors from your list as you need for this product. Select Primary Vendor - If you choose more than one, you can select whichever one will be your Primary Vendor for the item. The Primary vendor will be the one that displays by default for the item and will come up in vendor item searches when creating a new Purchase Order. In addition, the Low Inventory report and the Low Inventory view of the Inventory report will display the Primary Vendor of the item if it's inventory is at or below its Reorder Point (see the section below on Purchasing). Make- You can list the name of the maker brand here, and this can be different than the base Manufacturer if needed. Model- Enter the model name of the item here. Year- Enter the year of the model here. Taxes - By default, the item will use your primary physical product tax rate, which in the system is labeled as your Materials tax. If it needs to use a different rate or if the item is not taxable and needs no rate at all, you can click the drop-list and check / uncheck whatever boxes are necessary. Upload Media - As mentioned above, this area is actually visible from all tabs of the product and you can add images or animated media (GIF files) if you like at any point in your product creation process. You can drag and drop multiple files at once and all will load simultaneously. Once loaded, you can drag and drop the thumbnails into whatever order you need. Please see the article linked below on Images if you want further details on creating the best product shopping experience for your customers in this area. Product Details This area allows you to enter important information about the item. Here are the data points you can set in this section: Store Location - If you have multiple store locations in the system, you will see each of them in this area, either as they appear above or in a drop-list. As you enter data for the item, it will apply to the selected Location, but most data points here can be applied to all of your locations. As you're entering information, you'll see a link to Apply to All Locations, which will save you data entry time. Print Label - If you click this button at the top, it will load a label line item for every variant in the product, if it has variants as pictured below. All line items will default to print one label, but you can set whatever quantities you need. UPC- If the product has a Universal Product Code that is officially registered with the UPC organization, you can list it here. Codes of this type are always numbers only, and is a 12-digit identifier. It is also known as a GTIN (Global Trade Identifier Number) since it is used globally. Entering a code that is not registered can result in failed searches for the item, so it is recommended to enter only actual UPC codes for your items. Manufacturer Number - If the manufacturer for the item has an identifier code they use you can enter it here for reference and searches. You can enter alphanumeric characters and common punctuations and symbols if needed. SKU- By default, a unique SKU will appear here with each new product you create. You can adjust this to whatever you need, using alphanumeric characters as well as common punctuations and symbols. Alternate Barcode Title - By default, when you print a barcode label, the title for the barcode itself will be the Product Title Plus any Variant Name, but if you want to display something different on the label for the product you can enter an Alternate Barcode Title here and the system will use that when printing the label for the product. Alternate Lookups - If you have alternative names for a variant that you use internally, you can enter those terms here and when searching for the items anywhere in the system, e.g. Register, Products page, etc., the item will come up in searches using those terms. Add Alternate Lookup Row - If you need more Alternate Lookups you can click this button and add as many as you like. Weight- You can enter weight values for your items here. This will use your store default measurement system, which will either decimal values of pounds or kilograms for Weight. The values you enter here for weight will work with system weight-based shipping methods. The values you enter for weight will work for our integrations with Shipstation, Reverb, and Shopify. Product Dimensions - You can also enter dimension values for your item this area. These will use your store default measurement system, which will either be inches or centimeters for Height, Width, and Length. The values you enter for dimensions will also work for our integrations with Shipstation, Reverb, and Shopify. Condition- If you have non-serialized Conditions enabled (under Settings > Website Settings > Products) you can select the Condition of the item here. Conditions include Brand New, Like New, Mint, Excellent, Very Good, Good, Used, Fair, Poor, Non-Functioning, and Floor Model. Finish / Color - If the item has a special Finish, e.g. glossy or matte, or a particular Color, you can enter a brief description here of those features. Pricing In this section, you can enter price values for all prices you have enabled in the system for your items. Price- Enter your normal selling Price for the item here. If you do not use Website Price fields, this price will be used for your sales online and in-store. Sale Price - If you sell the item at a discounted price, you can enter that manually here. Transactions in the Register will show the original Price and your Sale Price so customers will know how much you love them. Online, if you're not using the website price fields, the Price will be crossed out and the Sale Price will display. Useful tools such as the Scheduled Sale tool under the Marketing menu allow you to schedule sale prices to be put into products and removed again when the sale is finished. MAP Price - If you have manufacturers that require you to respect MAP Price (minimum advertised price) you can enter that value here and the system will warn you whenever you try to save a price for the item that would be below your MAP guideline. Website Price - If you need to have different pricing in-store and online, you can use the Website Price to enter the standard price for the item that will appear online. If you don't see this field and want to use website pricing, you can enable it under Settings > Features > Website Pricing. Website Sale Price - If you want to sell online at a discount you can either enter a Website Sale Price here manually or schedule the pricing to be saved here automatically using the Scheduled Sale tool, which will also remove the online sale price after your sale is over. When a price is in this field, the regular Website Price will display crossed out, and the website sale price will be active. Reverb Price - If you are integrated with Reverb and if the item is synced to your Reverb online store, you can enter the selling price for it here. Wholesale Price (Not Pictured) - If you use our online Wholesale selling system, you can list the Wholesale Price for your item here. Only customers with active wholesale login credentials will be able to see this pricing. Purchasing If this is a product you plan to re-order in the future, you can enter purchasing information here that will be used by our Purchase Order / Receiving Order system. Vendor Name - Each of the Vendors you have set for the product will appear here, and whichever is the Primary Vendor will be indicated. Vendor Part Number - If the vendor has a part number they need to see on purchase orders, you can enter that part number here. These codes can use alphanumeric characters and common symbols and punctuation and will be visible on the PO as well as in the Low Inventory report and the Inventory report's low inventory view. Packaging- If the item has consistent packaging used by the vendor, you can enter that here so the system will order it according to the specifications. Enter how many of the items are in each container, the item type in the second dropdown (if the item is individual Items, or if it's sold by Inches, Feet, Yards, or Meters), and the packaging type in the final dropdown (if it's sold by the Case, Bolt, Box, Roll, or Pack). Apply to All Store Locations - If you will use the same Vendor information for your purchasing from all of your store locations, you can click this link to apply what you've entered across all your stores. Default Cost - This is what you expect your cost to be the next time you order the item. This field updates automatically based on the last Receiving Order cost for the item. Please note that for each shipment you receive for the item a unique Cost will be saved and tracked for your reporting so your profit margins will be accurate historically. Your Default Cost is not used in the reports. Reorder Point - If you want this product to be included in our automated reordering recommendations, you will want to set the Reorder Point value. When the product's inventory gets down to this value, it will appear on the Low Inventory report or in the Low Inventory view of the main Inventory report. It will also display in the Purchase Queue when doing a Purchase Order for any of the Vendors saved for the product. Desired Stock Level - Again, if you are wanting this product to be included in our automated reordering recommendations, you can set a Desired Stock Level. When adding the item to a Purchase Order or Receiving Order, the system will make sure the quantity being ordered will result in an inventory level that is at or above the number entered here. For example, If the product pictured above is down to 1 item in stock and it's added to a Purchase Order, the system will recommend ordering a case of 6 items, which will bring the stock level to 7. Deactivating and Saving At the bottom of every tab, you'll have the saving and closing options detailed below, but only on the Product Information tab will you see your options for deactivating the item. Here is what you can do with those functions: Deactivate Item for This Location - If you don't need to have the item active at the specific Location you are currently viewing, you can Deactivate it with this toggle. It will still be active for your other locations. Deactivated items do not display online, in searches in your system, or in the Register. Deactivate Product - This toggle will Deactivate the product for all of your store locations. Deactivating is like a light version of deleting the product and is useful for temporarily making a product inactive until you are able to reorder it and get it back in stock. It will not display online, will not come up in any system searches for you, and will not be available in the Register. You can find your deactivated items from Inventory > Products by clicking Filters and in the Product Status area, selecting Deactivated. Please note, if the product has multiple variants, this function deactivates all of them for all locations. Save Product - Clicking this will save whatever changes you might have made in the item, but will keep the product window open in case you need to continue working. Save Actions - If you are done making changes in the item, the default Save & Close button will save those updates and then close the window, taking you to the main Products list page. If you click the down arrow, you can see the option to Save & Duplicate, which will save the current product and copy everything except identifiers and images into a new product that will open for you as a copy. In the dropdown you also have the option to Save & New, which will save the current product and open a new blank one for you to start on. Delete- Our system uses what is known as a 'soft-delete', and that means if you decide to delete the item and later need it back, you can reactivate it. Deleting a product is good if it's sold out and you're sure you won't be reordering it again, and removes it from searches in the system, from the website, and from the Register. If you need to find it again, you can go to Inventory > Products, click the Filters button in the upper right, go to Product Status, and filter for Deleted items. Reopen the item from there and you can activate it again at the bottom. Close- Clicking to Close the product will close the window. If you have unsaved changes, you will be reminded to save them just in case. * Example images, the BigMe logo, and Bigme InkNote Color+ Kaleido3 are copyright BigMe and are used here for not-for-profit demonstration purposes only. Explore Version 3.0 of the Product Page: Overview Images Variants Serialized Items Product Information Tab Inventory Tab Website Settings Tab Advanced Settings Tab Notes Tab Reverb Tab Inventory add edit product page ecommerce features wholesale}'}, {id=191604258996, createdAt=1750439292929, updatedAt=1753712801802, path='spreadsheets-tips-and-tricks-from-the-pros', name='Spreadsheets - Tips and Tricks from the Pros', 2='{type=string, value=https://rainpos.my.site.com/s/article/Spreadsheets-Tips-and-Tricks-from-the-Pros}', 4='{type=list, value=[{id=1, name='rain_pos', order=0, label='Rain POS'}, {id=2, name='like_sew', order=1, label='Like Sew'}, {id=3, name='jewel360', order=2, label='Jewel360'}, {id=4, name='music_shop_360', order=3, label='Music Shop 360'}]}', 21='{type=number, value=0}', 6='{type=string, value=

Our pros on our Migration team work with spreadsheets all day, and are true wizards at working with data. They wanted to provide a resource for anyone working with bulk data using spreadsheets. The tips below are primarily for Excel, but represent general principles and practices you will want to follow in any spreadsheet program, or even in Google Docs. NOTE: Working with spreadsheets in our system is a highly technical process and is not for everyone! You can edit your product data directly in the Products module, as needed, so the following information is only for those who wish to optionally work with spreadsheets to work with products in bulk.

 

Scientific Notation

  • Excel will always convert large numbers such as your UPCs and SKUs into scientific notation, which will cause a lot of problems if they are uploaded that way. Luckily this is very preventable and quite easy to correct in Excel. When you see that any of your values have been converted into scientific notation, you need to select that entire column (by clicking on the column letter at the top), right click on the selected area, click “Format Cells” and then select “Fraction.” The default choice for that option is just fine, even though that option seems like it makes no sense, it actually works well in preventing the scientific notation alteration.

Scientific Notation.png

 

Clear Formulas by Copying and Pasting as Values

  • Copying data and pasting it as values can prevent a lot of issues while working with a bulk spreadsheet. In fact, we recommend you make this your first step when you begin working with a bulk spreadsheet. Doing this is simple. You need to select all your data (press CTRL A), copy it (using CTRL C), right click any selected cell and select “Paste as Values.” The icon representing this is a small clipboard with a blank sheet clipped on it with the numbers 1-3 on the bottom. What this will do is remove any information that is related to Excel formulas, which you do not want when uploading your data.

Paste as Values.png

 

Preserve Leading 0’s in Product IDs

  • If you have UPC codes or SKUs which start off with the number 0 you will want to be aware of this issue. In the world of mathematics and numbers, zeroes in front of other numbers, no matter how many, have no meaning and are typically removed by programs like Excel. For example, 0000001 and 1 represent the exact same value. Because of this, Excel will simply convert this number into an easier to view format and remove every leading 0. However, if this value is a UPC or SKU, then we would need to keep these leading 0s for this item to scan properly in our system.

To prevent this from happening, you will first need to re-format the cells as Text. You can do this by highlighting the desired cells or columns, right click in the selected area, click “Format Cells,” click “Text” and then press “OK.” These values will now be treated as text and retain any alpha or numeric character regardless of position.

Leading 0s.png

 

Custom Sorting

  • Sorting your data in Excel can be extremely helpful if done properly, but very damaging to your data if done incorrectly. You essentially have two choices when sorting: either sort all the data together or not. In almost all cases you will want to sort your data together. For example, you have a list of products that are currently listed in alphabetical order by the product title. Perhaps you would like to see which products are oldest based on their creation date. To do this you need to select the entire spreadsheet by clicking on the corner to the left of the letter A of the A column or by pressing CTRL A on your keyboard. With everything selected click on “Sort & Filter” found in the top right corner of Excel and then select “Custom Sort.” Select the column you wish to sort by and then press “OK.” If your data has headers, be sure to check the box “My Data Has Headers” found in the top right corner of that window.
  • If you are working with products that have Option Values, you need to be very careful to make sure they stay in their original order. Below is a video of how you can do this, recorded by our director of Migration, Sean Hall.

Custom Sort.png

 

The VLOOKUP Function

  • The VLOOKUP function can be an extremely helpful tool when trying to identify data that matches certain criteria. For example, if you wanted to remove any product in your system that has an inventory count of zero, you would need to use both the Edit Existing Products and Edit Existing Inventory spreadsheets. You would want to sort the inventory spreadsheet by the inventory count and then use a VLOOKUP to mark those products as “deleted” or “deactivated” on the other spreadsheet.
  • The following web page provides a very detailed and clear explanation of the VLOOKUP function: http://spreadsheeto.com/vlookup/
  • Additionally, you can follow this link for some additional info on this function: https://support.office.com/en-us/article/VLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1

Vlookup.png

This image above is of the data that we are looking for in a VLookup. If the function finds a match here in column A, we want it to return the value in column B.

Vlookup Returned.png

The image above is the result of the VLookup function. It found a matching product title listed on sheet1 and returned the associated value.

 

Don’t Close the Workbook

  • Excel does some interesting things when closing and re-opening a workbook, such as converting numerical values into scientific notation. To avoid things like this, you will want to save the document and upload it without closing it until you have successfully uploaded your data or have finished working with the spreadsheet. When using the bulk spreadsheets, it is highly recommended that you do not close and re-open those workbooks until you know you have successfully finished uploading/updating your data.

 

10,000 Rows or Less

  • There is no formal restriction on file size when uploading a bulk spreadsheet. However, we have found that our system begins to struggle fully inputting data if the spreadsheet you are working with has more than 10,000 rows. If you have a sheet that is longer than 10,000 rows, we recommend splitting that spreadsheet into multiple sheets of less than 10,000 rows each.

 

Data Displaying Incorrectly

  • There are some scenarios in which data will display awkwardly in Excel. Two examples are dates and numbers in scientific notation. If you have a date listed in a cell and that cell is not wide enough to display the full text, you will instead see, “########”. This is easily corrected by expanding the width of that column. Scientific notation is easily corrected by converting those cells into numbers.
  • The first thing to ask yourself when data is displaying incorrectly in the spreadsheet is, “Is the column wide enough?” and the second thing is, “Are these cells formatted as text or numbers?”

 

Only Upload Changed Data

  • If you are using any of the bulk spreadsheets, it is highly recommended that you only keep the data you are trying to update. Deleting the unnecessary rows will make it easier for our servers to process the upload. Anything you remove from the spreadsheet will not be affected In any way: your updates are only going to be affected by changes you make in the data itself.

 

Don’t Remove or Add Columns

  • Our spreadsheets are formatted in a way that is acceptable by our database. If this format is adjusted by adding or removing columns it will not upload. For example, there is only one address column in the customers bulk spreadsheet. Both the street address and apt/suite number need to be included in this single column. If you add an “address 2” column for this information then the system will not recognize the formatting and will reject the upload.

 

Uploading Blank Cells

  • Our system will essentially ignore blank cells when they are uploaded. A blank space, when uploaded, is the equivalent of not changing that data at all and tells they system, “make no change to this value.”
  • Make sure that whatever value you are trying to remove is replaced with an actual character such as a space or a 0. Deleting the contents of a cell will NOT remove it from your system! You must enter something to replace whatever you're removing.

Blank cells.png

 

Spreadsheet Type Overview

You can get to this part of the system by going to Products > Bulk. In the Spreadsheet drop list, select the spreadsheet you want and if you like, you can Filter by Department, Category, or Vendor (if you have vendors set up in your system). Click the Download link to download your spreadsheet. When you are done with the changes, you will do exactly the same steps, selecting the same spreadsheet you downloaded in the list, but without setting any filters, then click the Upload link and follow the instructions to upload your spreadsheet.

Here are some good things to know about the current offering of specific spreadsheets you can download and work with in our system:

Add New Products - Any time you want to add products by spreadsheet, download the latest version of this blank spreadsheet to work from! It may change periodically. You do NOT want to work from a previously saved version of this spreadsheet, as uploading the same products more than once with this sheet will duplicate them in the system, so please, always, work from a fresh download.

Edit Existing Products - Use this spreadsheet for working with general product data for products that are already saved in the system. This is the one you will want to use to adjust info about the product's category, title, descriptions, identifier codes (UPC, Manufacturer ID, SKU), status (active, deactivated, or deleted - if you want to delete products with an upload, use that last status, removing the line items doesn't remove a product from our system), and tax code, among other things.

Edit Existing Products, Long - This spreadsheet is only necessary if you need to work with your Long Descriptions. Please note, that the CSV format is plain-text only, so you will want to use that field only for simple block text. You can then go into the product and do any formatting you might need, e.g. bold, italics, bullet points, etc.

Add New Inventory - Use this spreadsheet if you want to add inventory quantities and costs to products you already have saved in the system. It will add a line-item entry to the product's inventory log with the new quantities and costs in place. Please note that only the Add Inventory, Add Cost, Edit Unlimited Inventory (to set it yes or no for unlimited inventory on the website), and the Inventory Note columns can actually be edited. The other fields will NOT update data changes.

Edit Existing Inventory - If you need to change inventory numbers or costs that are already in place for your products, you can use this spreadsheet. Please note that only the Edit Inventory, Edit Cost, and the Inventory Note columns can actually be edited. The other fields will NOT update data changes.

Edit Cost for Inventory with No Cost - This spreadsheet wins the award for Most Convoluted Name. It is also the best way to identify items in your system that have zero cost and add that cost for them. Please note that only the Cost column in this spreadsheet should be edited, the others are just for reference and will NOT update data changes.

Categories - This is a great spreadsheet to download and print out if you'll be doing a lot of work with your Category ID numbers, something you will need access to if you're moving products into different categories and/or adding them to multiple categories. This spreadsheet is purely for reference.

FabShop-Specific Inventory File - If you are a member of the FabShop product listing service, you can download this file to submit to them monthly so they can index your inventory with their directory service.

Product Images - This download gives you a list of all product images (in the Images tab and in the image below the pricing area for the product) along with the image URLs. This spreadsheet is for reference only and is not a way to bulk upload images. To learn how to bulk upload images, click here: Bulk Upload Images.

Google XML Product Feed - If you need to manually update your product listing with Google, you can download this file and submit it for that purpose.

SVP Export - This spreadsheet will contain data specific to Serialized Inventory you have sold and is used for SVP dealers. You can set the time frame you want the data to cover, and it provides useful bulk information about all serialized items sold during the period. If you are not an SVP dealer, this spreadsheet may still have useful information for you for reference on your serialized sales.

svp dates.png

}', 22='{type=option, value={id=2, name='recommended_extra', order=1, label='Recommended Extra'}}', 23='{type=list, value=[{id=1, name='featured_content', order=0, label='Featured Content'}]}', 24='{type=list, value=[{id=5, name='bulk', order=4, label='Bulk'}]}', 9='{type=string, value=Spreadsheets - Tips and Tricks from the Pros}', 25='{type=number, value=0}', 26='{type=list, value=[{id=190209692537, name='Inventory'}]}', 28='{type=string, value=Spreadsheets - Tips and Tricks from the Pros Our pros on our Migration team work with spreadsheets all day, and are true wizards at working with data. They wanted to provide a resource for anyone working with bulk data using spreadsheets. The tips below are primarily for Excel, but represent general principles and practices you will want to follow in any spreadsheet program, or even in Google Docs. NOTE: Working with spreadsheets in our system is a highly technical process and is not for everyone! You can edit your product data directly in the Products module, as needed, so the following information is only for those who wish to optionally work with spreadsheets to work with products in bulk. Scientific Notation Excel will always convert large numbers such as your UPCs and SKUs into scientific notation, which will cause a lot of problems if they are uploaded that way. Luckily this is very preventable and quite easy to correct in Excel. When you see that any of your values have been converted into scientific notation, you need to select that entire column (by clicking on the column letter at the top), right click on the selected area, click “Format Cells” and then select “Fraction.” The default choice for that option is just fine, even though that option seems like it makes no sense, it actually works well in preventing the scientific notation alteration. Clear Formulas by Copying and Pasting as Values Copying data and pasting it as values can prevent a lot of issues while working with a bulk spreadsheet. In fact, we recommend you make this your first step when you begin working with a bulk spreadsheet. Doing this is simple. You need to select all your data (press CTRL A), copy it (using CTRL C), right click any selected cell and select “Paste as Values.” The icon representing this is a small clipboard with a blank sheet clipped on it with the numbers 1-3 on the bottom. What this will do is remove any information that is related to Excel formulas, which you do not want when uploading your data. Preserve Leading 0’s in Product IDs If you have UPC codes or SKUs which start off with the number 0 you will want to be aware of this issue. In the world of mathematics and numbers, zeroes in front of other numbers, no matter how many, have no meaning and are typically removed by programs like Excel. For example, 0000001 and 1 represent the exact same value. Because of this, Excel will simply convert this number into an easier to view format and remove every leading 0. However, if this value is a UPC or SKU, then we would need to keep these leading 0s for this item to scan properly in our system. To prevent this from happening, you will first need to re-format the cells as Text. You can do this by highlighting the desired cells or columns, right click in the selected area, click “Format Cells,” click “Text” and then press “OK.” These values will now be treated as text and retain any alpha or numeric character regardless of position. Custom Sorting Sorting your data in Excel can be extremely helpful if done properly, but very damaging to your data if done incorrectly. You essentially have two choices when sorting: either sort all the data together or not. In almost all cases you will want to sort your data together. For example, you have a list of products that are currently listed in alphabetical order by the product title. Perhaps you would like to see which products are oldest based on their creation date. To do this you need to select the entire spreadsheet by clicking on the corner to the left of the letter A of the A column or by pressing CTRL A on your keyboard. With everything selected click on “Sort & Filter” found in the top right corner of Excel and then select “Custom Sort.” Select the column you wish to sort by and then press “OK.” If your data has headers, be sure to check the box “My Data Has Headers” found in the top right corner of that window. If you are working with products that have Option Values, you need to be very careful to make sure they stay in their original order. Below is a video of how you can do this, recorded by our director of Migration, Sean Hall. The VLOOKUP Function The VLOOKUP function can be an extremely helpful tool when trying to identify data that matches certain criteria. For example, if you wanted to remove any product in your system that has an inventory count of zero, you would need to use both the Edit Existing Products and Edit Existing Inventory spreadsheets. You would want to sort the inventory spreadsheet by the inventory count and then use a VLOOKUP to mark those products as “deleted” or “deactivated” on the other spreadsheet. The following web page provides a very detailed and clear explanation of the VLOOKUP function: http://spreadsheeto.com/vlookup/ Additionally, you can follow this link for some additional info on this function: https://support.office.com/en-us/article/VLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1 This image above is of the data that we are looking for in a VLookup. If the function finds a match here in column A, we want it to return the value in column B. The image above is the result of the VLookup function. It found a matching product title listed on sheet1 and returned the associated value. Don’t Close the Workbook Excel does some interesting things when closing and re-opening a workbook, such as converting numerical values into scientific notation. To avoid things like this, you will want to save the document and upload it without closing it until you have successfully uploaded your data or have finished working with the spreadsheet. When using the bulk spreadsheets, it is highly recommended that you do not close and re-open those workbooks until you know you have successfully finished uploading/updating your data. 10,000 Rows or Less There is no formal restriction on file size when uploading a bulk spreadsheet. However, we have found that our system begins to struggle fully inputting data if the spreadsheet you are working with has more than 10,000 rows. If you have a sheet that is longer than 10,000 rows, we recommend splitting that spreadsheet into multiple sheets of less than 10,000 rows each. Data Displaying Incorrectly There are some scenarios in which data will display awkwardly in Excel. Two examples are dates and numbers in scientific notation. If you have a date listed in a cell and that cell is not wide enough to display the full text, you will instead see, “########”. This is easily corrected by expanding the width of that column. Scientific notation is easily corrected by converting those cells into numbers. The first thing to ask yourself when data is displaying incorrectly in the spreadsheet is, “Is the column wide enough?” and the second thing is, “Are these cells formatted as text or numbers?” Only Upload Changed Data If you are using any of the bulk spreadsheets, it is highly recommended that you only keep the data you are trying to update. Deleting the unnecessary rows will make it easier for our servers to process the upload. Anything you remove from the spreadsheet will not be affected In any way: your updates are only going to be affected by changes you make in the data itself. Don’t Remove or Add Columns Our spreadsheets are formatted in a way that is acceptable by our database. If this format is adjusted by adding or removing columns it will not upload. For example, there is only one address column in the customers bulk spreadsheet. Both the street address and apt/suite number need to be included in this single column. If you add an “address 2” column for this information then the system will not recognize the formatting and will reject the upload. Uploading Blank Cells Our system will essentially ignore blank cells when they are uploaded. A blank space, when uploaded, is the equivalent of not changing that data at all and tells they system, “make no change to this value.” Make sure that whatever value you are trying to remove is replaced with an actual character such as a space or a 0. Deleting the contents of a cell will NOT remove it from your system! You must enter something to replace whatever you're removing. Spreadsheet Type Overview You can get to this part of the system by going to Products > Bulk. In the Spreadsheet drop list, select the spreadsheet you want and if you like, you can Filter by Department, Category, or Vendor (if you have vendors set up in your system). Click the Download link to download your spreadsheet. When you are done with the changes, you will do exactly the same steps, selecting the same spreadsheet you downloaded in the list, but without setting any filters, then click the Upload link and follow the instructions to upload your spreadsheet. Here are some good things to know about the current offering of specific spreadsheets you can download and work with in our system: Add New Products - Any time you want to add products by spreadsheet, download the latest version of this blank spreadsheet to work from! It may change periodically. You do NOT want to work from a previously saved version of this spreadsheet, as uploading the same products more than once with this sheet will duplicate them in the system, so please, always, work from a fresh download. Edit Existing Products - Use this spreadsheet for working with general product data for products that are already saved in the system. This is the one you will want to use to adjust info about the product's category, title, descriptions, identifier codes (UPC, Manufacturer ID, SKU), status (active, deactivated, or deleted - if you want to delete products with an upload, use that last status, removing the line items doesn't remove a product from our system), and tax code, among other things. Edit Existing Products, Long - This spreadsheet is only necessary if you need to work with your Long Descriptions. Please note, that the CSV format is plain-text only, so you will want to use that field only for simple block text. You can then go into the product and do any formatting you might need, e.g. bold, italics, bullet points, etc. Add New Inventory - Use this spreadsheet if you want to add inventory quantities and costs to products you already have saved in the system. It will add a line-item entry to the product's inventory log with the new quantities and costs in place. Please note that only the Add Inventory, Add Cost, Edit Unlimited Inventory (to set it yes or no for unlimited inventory on the website), and the Inventory Note columns can actually be edited. The other fields will NOT update data changes. Edit Existing Inventory - If you need to change inventory numbers or costs that are already in place for your products, you can use this spreadsheet. Please note that only the Edit Inventory, Edit Cost, and the Inventory Note columns can actually be edited. The other fields will NOT update data changes. Edit Cost for Inventory with No Cost - This spreadsheet wins the award for Most Convoluted Name. It is also the best way to identify items in your system that have zero cost and add that cost for them. Please note that only the Cost column in this spreadsheet should be edited, the others are just for reference and will NOT update data changes. Categories - This is a great spreadsheet to download and print out if you'll be doing a lot of work with your Category ID numbers, something you will need access to if you're moving products into different categories and/or adding them to multiple categories. This spreadsheet is purely for reference. FabShop-Specific Inventory File - If you are a member of the FabShop product listing service, you can download this file to submit to them monthly so they can index your inventory with their directory service. Product Images - This download gives you a list of all product images (in the Images tab and in the image below the pricing area for the product) along with the image URLs. This spreadsheet is for reference only and is not a way to bulk upload images. To learn how to bulk upload images, click here: Bulk Upload Images. Google XML Product Feed - If you need to manually update your product listing with Google, you can download this file and submit it for that purpose. SVP Export - This spreadsheet will contain data specific to Serialized Inventory you have sold and is used for SVP dealers. You can set the time frame you want the data to cover, and it provides useful bulk information about all serialized items sold during the period. If you are not an SVP dealer, this spreadsheet may still have useful information for you for reference on your serialized sales. Inventory bulk}'}]

Search results for: Work Order Lookup

AI Overview

We`re looking into that for you ...

Sort by Relevance

No exact match found. We are trying to find relevant matches. Please wait or add a new keyword.