Uploading Products and Managing SKUs

Uploading Products and Managing SKUs

Print

Once brand and/or product categories have been added, you can now begin uploading your products. You can differentiate product types between simple and variable. Simple products are those that do not have any product variations. Variable products, on the other hand, are those that have at least one variant for your customers to choose from.


Stock Keeping Units (SKUs), meanwhile, are alphanumeric codes used as identifiers assigned by the retailers to their products. Each item, variation, and add-on should have its own code to make it easier for merchants to differentiate every aspect/kind of product from another based on what merchants deem important (ex. color, size, etc.). Apart from product differentiation, SKUs are also used by merchants to monitor their stocks / inventory.


In this article:

  1. Individual Product Upload
  2. Bulk Upload
  3. Managing and Updating Products

To start selling from your RUSH eStore, one of the first and most important things to do is to add your products and build your catalog. This allows your customers to find your products from your online store.

You can choose to upload your products individually using the “Add New Product” function. For stores with a bigger catalog and longer list of products, however, we recommend that you upload them in one using the Bulk Upload buttons in the CMS.


Individual Product Upload

To add simple products one by one from your eStore module:

  1. Go to the Products tab, which displays all your uploaded products, their categories and types, variations, SKU, and price.

  2. Click the +Add New Product.

  3. On the product set-up window, input the product name and description.

  4. On the variation option, select Simple.

  5. Select the product category from the dropdown menu.

  6. On the right window, input the product price and SKU.

  7. If applicable, create add-ons:

    1. Provide the add-on variation name.

    2. Add the variations of each add-on

    3. Input the number of variables for each add-on

    4. Once all add-ons are set up, click Generate.

    5. On the right window, configure each add-on by toggling on/off the applicable options

      1. If the add-on is tagged as free, just input the SKU

      2. If the add-on comes with a fee, toggle off the free option, input the price, and input the SKU

    6. Set the maximum add-on selection.

  8. Upload product images.

  9. Once done, click Save Product.


To add variable products one by one from your eStore module:

  1. Go to the Products tab, which displays all your uploaded products, their categories and types, variations, SKU, and price.

  2. Click the +Add New Product.

  3. On the product set-up window, input the product name and description.

  4. On the variation option, select Variable.

  5. Select the product category from the dropdown menu.

  6. Click +Add Attribute to add variant attributes:

    1. Provide the attribute name (ex. Size, color, material, etc.)

    2. Enter variation name (ex. small, medium, large)

      1. To add more variations under each attribute, click +Add Variation and input variation name

    3. Click Generate.

    4. On the right window, input the price and SKU of each variation

  7. If applicable, create add-ons:

    1. Provide the add-on variation name.

    2. Add the variations of each add-on

    3. Input the number of variables for each add-on

    4. Once all add-ons are set up, click Generate.

    5. On the right window, configure each add-on by toggling on/off the applicable options

      1. If the add-on is tagged as free, just input the SKU

      2. If the add-on comes with a fee, toggle off the free option, input the price, and input the SKU

      3. Set the maximum add-on selection.

  8. Upload product images.

  9. Once done, click Save Product.



Bulk Upload

Uploading a list of products is a more convenient way of adding inventories to your store. Before doing a batch upload, download the templates available on the CMS (.zip file of CSV template and image folder) which you can download from the button next to the upload button. Clicking download will give you a zip file for that corresponding Bulk Upload type.


 

To edit the .zip files:

  1. Add all the Product images you want to use in the images folder.
    Make the filenames for the images easy to type in. This will be important later.
  2. Edit the .csv file with the products you want to upload.
  3. Click Upload Simple Product and choose the .zip file to be uploaded
  4. Click Save and wait for the upload to finish.
  5. Double check the uploaded products by refreshing the page and searching for a product.

To edit the .csv file for Simple Bulk Upload:

  1. Input the Name of the product (max. 50 characters)
  2. Input the product Description (max. 300 characters)
  3. Input the corresponding image name for the product and include the file extension (e.g. product.jpg, burger.png, etc).
  4. Add the unique SKU code to be associated with the product
  5. Set the default stock quantity for the initial upload
  6. For Currency, enter “PHP”
  7. Enter the Price of the product
  8. Set On Sale to 0
  9. Set Visibility to 1

Items 8 and 9 use a binary code. For these cases, 0 means "yes" and 1 means "no".

To edit the .csv file for Variable Bulk Upload:

  1. Input the Name of the product (max. 50 characters)
  2. Input the product Description (max. 300 characters)
  3. Input the corresponding image name for the product and include the file extension (e.g. product.jpg, burger.png, etc).
  4. Add the unique SKU code to be associated with the product
  5. Set the default stock quantity for the initial upload
  6. For Currency, enter “PHP”
  7. Enter the Price of the product
  8. Set On Sale to 0
  9. Set Visibility to 1
    Items 8 and 9 use a binary code. For these cases, 0 means "yes" and 1 means "no".
  10. Product variations need to be created under Variation Attribute:
    1. Use the following format: {attribute 1} : {variation 1} | {variation 2} + {attribute 2} : {variation 1} | {variation 2} + {attribute x} : {variation 1} | {variation x}
      1. "+" separates each attribute
      2. ":" separates attribute (1) and variations
      3. "|" separates each variations
    2. For example: Flavor: Chocolate | Vanilla + Size: Pint | Tub will generate 2 attributes: Flavor and Size
      1. Flavor attribute has 2 variations: Chocolate and Vanilla
      2. Size attribute has 2 variations: Pint and Tub
      3. Customer will be able to choose between the 2 different flavors and 2 different sizes when ordering this item
  11. For each variation you have created, an SKU code, quantity of inventory, and price for each variation should be added:
    1. Use the following format: {variation 1 of attribute 1}_{variation 1 of attribute 2} : {SKU code for the combination} | {Stock count} | {Price for the combination} + {variation 2 of attribute 1}_{variation 1 of attribute 2} : {SKU code for the combination} | {Stock count} | {Price for the combination} + {variation x of attribute x}_{variation x of attribute x} : {SKU code for the combination} | {Stock count} | {Price for the combination}
      1. "+" separates each attribute
      2. ":" separates attribute (1) and variations
      3. "|" separates each variations
    2. For example: Chocolate_Pint: CHPINT|10|100.00 + Chocolate_Tub: CHTUB|10|200.00 + Vanilla_Pint: VNPINT|15|90.00 + Vanilla_Tub: VNTUB|15|180.00
      1. Chocolate Pint: 10 SKUs at Php 100.00 each with SKU Code CHPINT
      2. Chocolate Tub: 10 SKUs at Php 200.00 each with SKU Code CHTUB
      3. Vanilla Pint: 15 SKUs at Php 90.00 each with SKU Code VNPINT
      4. Vanilla Tub: 15 SKUs at Php 180.00 each with SKU Code VNTUB


Sample files can be downloaded from this link. Look for the file you want to download then right click to download. Once the form is accomplished and images are added into the image folder, you can upload your product list.


To upload your list of simple products from the Products tab of your eStore module:

  1. Click Upload Simple Product

  2. Select the appropriate .zip folder which should contain:

    1. The accomplished Simple Product .CSV file

    2. The image folder with all product images

  3. Confirm upload.


To upload your list of variable products from the Products tab of your eStore module:

  1. Click Upload Variable Product

  2. Select the appropriate .zip folder which should contain:

    1. The accomplished Simple Product .CSV file

    2. The image folder with all product images

  3. Confirm upload.

Managing and Updating Products

The CMS enables you to update the following information on your uploaded products:

  1. Product Name

  2. Product Description

  3. Product Category

  4. Regular Price of each item, variation (if applicable), and add-on (if applicable)

  5. SKU number of each item, variation (if applicable), and add-on (if applicable)

  6. Product image


To update a product’s information from your eStore module:

  1. Go to the Products tab, which displays all your uploaded products, their categories and types, variations, SKU, and price.

  2. Choose the product you want to update and click the edit icon.

  3. On the pop-up window, input (or select, if applicable) the updated product information:

    1. Product name

    2. Product description

    3. New product category

    4. Regular Price of each item, variation* (if applicable), and add-on* (if applicable)

    5. SKU number of each item, variation* (if applicable), and add-on* (if applicable)

  4. Add or delete product images.

  5. Once all edits are made, confirm changes by clicking SAVE PRODUCT.


Only price and SKU numbers are the changes allowed for variations and add-ons. If you need to add or change the variations or add-ons, you need to delete the existing product and re-upload it with the updated add-ons and/or variation attributes.