We require this information in order to identify and describe your product details when you upload your products.
Here are the 7 fields that must be filled out in our template, along with descriptions of each:
SKU or style number (required): A SKU is a unique code for each size, color, or other variant a product may have. However, your product title is a better option if you're not using one. For open-packs, using the same SKUs or just the product title is acceptable.
Title (required): A product title is a one-liner sentence that best describes your product.
Visibility (required): This is where we can select the option to have the SKU or product active by using the drop-down Published and Unpublished if the SKU or product is sold out or is not to be displayed for now.
Category (required): This is the classification of your products. Hubventory's template requires you to use the list given in the tab titled "Valid Options," Column D. With your existing categories or keywords, find the best option to have as your category. Download the updated template by clicking this link:https://hubventory.com/dashboard/brand/products/import/csv
Price (required): The price you set for you product, either by the pack price & per piece price
Pack price is the total price of the pack or is to be provided when sizing is entered as a pack. Example: Women > Clothing > 2S, 2M, 2L
Price per piece is used when the size only refers to one item. Example: Women > Junior > 9
Description (required): This is the section where you can elaborate on your product and include all the information your buyer would need to know. If a product is made to order, it is best to note that here.
Product Images: Product images must be in jpg, png, or gif format and have a vertical ratio of 4/5 and a minimum of 1280 x 1600 pixels. There are 2 ways to upload your images inside Hubventory.
Using a CDN link exported from Shopify, Faire, or other platforms: Because the columns are arranged horizontally, make sure to move the links to their proper columns or use the TRANSPOSE formula.
Manual upload: by using the bulk photo upload inside Hubventory, the following should be observed:
The image file name (the name that you saved the file under) and SKU name (the name that will appear on the platform) need to be the same.
If the SKU has multiple colors, the file name should be as follows:
SKU is ABCD1234 with colors orange and gray; the file names should then be ABCD1234-orange and ABCD1234-gray.
If a SKU has multiple images, the file name should be in the same sequence as it would appear on Hubventory.
ABCD1234.1 , ABCD1234.2 , ABCD1234.3 , ABCD1234.4
ABCD1234-orange.1 , ABCD1234-orange.2 , ABCD1234-orange.3 , ABCD1234-orange.4
ABCD1234-gray.1 , ABCD1234-gray.2 , ABCD1234-gray.3 or ABCD1234.1
It should end with the file type as JPEG or PNG
Here are the remaining fields that are recommended but not required:
Sale Price: The sale price is the discounted price of the item. The original price will show as having been crossed out to highlight the sale price.
MSRP: This is the price that the brand recommends as the retail price.
Size: Size is either entered as the following:
Taken from valid options for pack size. Example: Women > Clothing > 2S, 2M, 2L. This serves as 1 pack; when ordered, it is a total of 6 items in 1 pre-pack.
Taken from valid options, as per piece. Example: Women > Junior > 9. This is 1 piece in the size Junior 9. And then, if you have a minimum quantity to order this size, indicate the quantity on the field, Case Quantity.
You, too, can create your own sizes inside the CSV template or on the Hubventory website. Before uploading your CSV file, you need to create a new size under Settings > Sizes and click on "Add New Size." You only need to fill in the necessary fields which are the Size (if it is pre-pack or per piece) and Quantity (Quantity for pre-pack must be set to 1.)
Color: A color variation of the same product.
Option Name: The option name is the title of a variant of the product or SKU that is specific or unique. This is best used when the variant is not a size or color.
Option Value: The option value is the value of the specific variant.
Case Quantity: The case quantity is the minimum number of items that should be ordered when choosing a product or SKU and is dependent on the size chosen.
Example scenario:
One (1) pack minimum to order SKU; details are the following:
Size is Women > Clothing > 2S, 2M, 2L
Pack price: $120
Case Quantity: 1
Added to cart: Quantity of 1 = Total order is 120 for 1 pack
One (1) order is a minimum of eight (8) items. Details are the following:
Size is Women > Junior > 9
Per piece price: $20
Case Quantity: 8
Added to cart: Quantity of 1 = Total order is $160 for 8 pieces of Junior > 9
No minimum to order and there's no pre-pack for the product or SKU
Size: M
Per piece price: $8
Case Quantity: 1
Added to cart: Quantity of 1 = total order then is $8 for 1 piece of size M
Keywords: Keywords are the best words to trigger your product when retailers are searching for products.
Fit: This refers to the overall category to which the product belongs. e.g., kids, men's, young contemporary.
Season: An added category where the product best belongs based on the drop-down events or particular weather.
Material: The substance from which the product is made or composed.
Dimension: A measurable extent of some kind, such as length, depth, or height.
Country of Origin: The country where the product was made.
Shipping At: This is the date when a specific variant can be shipped out or is available. It is a pre-order. Once the date has passed, it will be considered immediate. If this field is blank, the product will be listed as "immediate." For example, if there are 3 colors in one style, 2 of which are on hand but the other is pre-ordered, the pre-order style should have a date.
Weight: The weight of the product. When referring to a pre-pack, the weight is the total weight of the pre-pack item, whereas when referring to a per-piece item, the weight is the weight of the actual item. The weight of a Hubventory product variant is only optional and has no impact on the load weight for shipping-related details.
Weight Unit: This field refers to the scale weight in kilograms (kg), pounds (lbs), or any other weight unit the brand will use.
Track Inventory: Enable track inventory by choosing Yes from the drop-down menu. Once the count reaches zero or as soon as the count is not enough to supply the minimum quantity of a pre-pack or the case quantity, the SKU or the product will automatically be unpublished.
Inventory Count: This is the actual count or number of the SKU or product per unit. In the event that it is per pack count, make sure to get the total pieces as the inventory count number.
Lead Time: Indicate how many days you need to prepare the order for shipping. Particularly for made-to-order cases where a fixed number of days is required to comply with the ordered product before shipping out. For your convenience, if all your products are made-to-order, it’s best to use the global lead time feature, which can be found in Settings > Orders > Lead Time. Global Lead Time will take effect if there is no lead time indicated in every variant or if there is no shipping date indicated.
Allows Customization: This field applies to those products that may need to be customized before shipping.