1. Solid Commerce
  2. Microsoft Excel Add-In Tool
  3. The Solid Commerce Excel Add-In Tool

Using the Webuploader

Avatar
Christina Harris
Follow

Upload Products Using Web Uploader

Using the Web Uploader is an alternative way to upload files into Solid Commerce. It can be an option if you do not have the Excel Add-In Tool (Windows compatible only) or if you have custom files without Solid Commerce compatible headers. This is also a nice option for large files as this process occurs in the background on your computer.
There are two options when uploading files in the Web Uploader:

  1. Upload your file using the Solid Commerce Excel File Format. This option allows you to use the Solid Commerce specific column names that are available in the Excel Add-In Tool.
  2. Upload your file using a custom template. This option requires you to create a custom mapping for your files to match your column names with the Solid Commerce specific column names.

1. Upload Using the Solid Commerce Excel File Format

Uploading using the Solid Commerce Excel File Format is the preferred alternative option, when available. The files you upload for this will need to have all the proper Solid Commerce column names. Follow the steps below once you've filled out your spreadsheet with the data you're ready to upload.

    1. Open the Excel file containing your product data and confirm your headers correspond to the Solid Commerce column names.
    2. Save the file as a Tab delimited (*.txt) file type.
      • NOTE: The Import Manager will only process (*.txt) files.
    3. In your Channels Manager account, navigate to Products > Import Products and Inventory
    4. Set up the Import Manager based on the following options available:
      • Templates: Leave the selection as Solid Commerce Excel File Format
      • Data update rule: Select one of the following options:
        • Overwrite existing inventory data + add new products: This option will overwrite existing product data and add products that have not yet been imported into Solid Commerce.
        • Overwrite existing inventory data - ignore new products: This option will overwrite existing product data but will nm add any products found in your Excel file that have not yet been imported into Solid Commerce.
      • Qty Update Option; If you select the box for Check to reset to zero all products not in import file, the quantity on any sku not included in your Excel will be set to O inside of Solid Commerce.
          • NOTE: Please use this feature very carefully. There is no way to undo this action.
        • Import options: Check the following boxes according to the type of data you are uploading:
          • Import Product: Select this box if you are uploading product-level data (yellow headers)
          • Import Inventory. Select this box if you are uploading inventory-level data (orange headers)
            • If selected, an additional drop-down box will appear with the following options:
              • Match by warehouse id (Default): This is the default option and should be used, if possible. This instructs the system to use the warehouse id value as the unique identifier to match the products and updates quantity for just that item.
              • Do not update multiple items: This instructs the system that it can use the warehouse id, product custom sku, and alternate skus. If multiple matching items are found, this option instructs the system to perform any quantity updates.
              • Update multiple items: This instructs the system that it can use the warehouse id, product custom sku, and alternate skus. If multiple matching items are found, this option instructs the system to update the quantity on fill items found.
            • Import Marketplace: Select this box if you are uploading marketplace-level data (green headers)
                • If selected, you will need to choose the proper Marketplace from the drop-down that appears below.
            • Parsing options: Set up the following options based on your file requirements:
              • Missing Header. Leave this box unchecked. It may be utilized if you are using a custom template.
              • Ignore Quotes: Leave this box unchecked. It may be utilized if you are using a custom template.
              • Skip First n Rows: You may have information in the top rows that you may want to keep. Enter the number of rows above the Solid Commerce headers row to instruct the system to skip those.
              • Process Multiple Files: Leave this box unchecked. It may be utilized if you are using an FTP automation for file ingestion.
              • Delete Source File After Processing: Leave this box unchecked. It may be utilized if you are using an FTP automation for file ingestion.
            • Web base URL: Leave this empty. It is used for setting up automated FTP uploads.
            • FTP Protocol: Leave this empty. It is used for setting up automated FTP uploads.
            • Web login: Leave this empty. It is used for setting up automated FTP uploads.
            • Web pass: Leave this empty. It is used for setting up automated FTP uploads.
            • FTP inventory file name: Leave this It is used for setting up automated FTP uploads.
            • Choose data file from local drive: Select Tab delimited (txt) from the drop-down and click Select to select the file you want to upload.
    5. Click Next and you will be brought to a new page letting you know your file was successfully uploaded into the queue successfully.
      • To view the progress and result of the file upload, navigate to Reports> Inventory Imports Status
        • Use the drop-down for Filter Import Status and select All Imports> click SEARCH

2. Upload Using a Custom File Format

If you have a file that has custom column headers that do not match the Solid Commerce column headers, you can set up a template to upload your file. Using this option still requires knowledge of the Solid Commerce column headers so you can properly set up your template. Follow the steps below once you have a copy of the file you will be uploading.

 

NOTE: You will need to make sure the values in your file are valid entries based off the requirements for the Excel Add-In Tool columns.

Example: If you have a custom column header titled Item Height, the proper Solid Commerce column name you map that to is Product Height. That field requires an integer (whole number, no decimals). You will need to make sure the values in Item Height follow those requirements.

If you had additional questions about this, please contact your Growth Advisor.

    1. Open the file containing your product data and confirm everything is accurate and properly formatted so it is ready to upload.
      • We recommend you keep a copy of the file open during this process for easy mapping
    2. Save your file in the desired format. Accepted file types are: .csv, .xlsx, .txt (tab delimited), and Custom Delimited (you will need to define the delimiter used and provide the file extension type).
    3. In your Channels Manager account, navigate to Products > Import Products and Inventory
    4. Set up the Import Manager based on the following options available:
      • Templates: Select Create New Template Mapping from the drop-down
        • If you've previously made a template for this file, you can select that template name from the drop-down
      • Template Name: Enter the name you wish to save for this template. You'll only need to build the template one time.
        • The only time you would need to re-do or update your template is if the format and columns on your file change.
      • Data update rule: Select one of the following options:
        • Overwrite existing inventory data + add new products: This option will overwrite existing product data and add products that have not yet been imported into Solid Commerce.
        • Overwrite existing inventory data - ignore new products: This option will overwrite existing product data but will not add any products found in your Excel file that have not yet been imported into Solid Commerce
        • Qty Update Option; If you select the box for Check to reset to zero all products not in import file, the quantity on any sku not included in your file will be set to O inside of Solid Commerce.
          • NOTE: Please use this feature very carefully. There is no way to undo this action.
        • Import options: Check the following boxes according to the type of data you are uploading:
          • Import Product: Select this box if you are uploading product-level data (yellow headers)
          • Import Inventory: Select this box if you are uploading inventory-level data (orange headers)
            • If selected, an additional drop-down box will appear with the following options:
              • Match by warehouse id (Default): This is the default option and should be used, if possible. This instructs the system to use the warehouse id value as the unique identifier to match the products and updates quantity for just that item.
              • Do not update multiple items: This instructs the system that it can use the warehouse id, product custom sku, and alternate If multiple matching items are found, this option instructs the system not to perform any quantity updates.
              • Update multiple items: This instructs the system that it can use the warehouse id, product custom sku, and alternate If multiple matching items are found, this option instructs the system to update the quantity on all items found.
            • Import Marketplace: Select this box if you are uploading marketplace-level data (green headers)
              • If selected, you will need to choose the proper Marketplace from the drop-down that appears
            • Parsing options: Set up the following options based on your file requirements:
              • Missing Header: Check this box if your file does not have any column headers.
              • Ignore Quotes: Check this box if there are quotes ( " ) in any of the fields in your Checking this will ensure those quotes are not seen as expressions or equations, just text.
              • Skip First n Rows: You may have information in the top rows that you want to keep, such as internal notes, but not Enter the number of rows above the true column headers to instruct the system to skip those.
              • Process Multiple Files: Leave this box unchecked. It may be utilized if you are using an FTP automation for file
              • Delete Source File After Processing: Leave this box It may be utilized if you are using an FTP automation for file ingestion.
            • Web base URL: Leave this empty. It is used for setting up automated FTP uploads.
            • FTP Protocol: Leave this empty. It is used for setting up automated FTP uploads.
            • Web login: Leave this It is used for setting up automated FTP uploads.
            • Web pass: Leave this It is used for setting up automated FTP uploads.
            • FTP inventory file name: Leave this It is used for setting up automated FTP uploads.
            • Choose data file from local drive: Select the proper file format you will be using from the drop-down and click Select to select the file you want to upload.
              • If you select Excel, it will ask you to provide the sheet Make sure you enter the value exactly as it is seen on the sheet name in Excel.
    5. Click Next and you will be brought to a new page to set up your mapping, if you have selected Create New Template Mapping in the beginning. If you are applying a template you've already made, clicking Next will be bring you to a new page letting you know your file was successfully uploaded into the queue successfully.
      • To view the progress and result of the file upload, navigate to Reports > Inventory Imports Status
        • Use the drop-down for Filter Import Status and select All Imports> click SEARCH

 

2.1  Setting Up Your Custom Template Mapping

When you are brought to this mapping page, you will see a table with 6 columns. Each row is significant of a column header detected in the file you uploaded. You will need to go through each row and fill it out based on how you want the file mapped. Below is a description of each column and the options available for filling it out.

  1. SOLIDCOMMERCE FIELD: The value you select for this column will determine the field in Solid Commerce you want to map the data for this row to. By default, Ignore Column, is populated, allowing you to choose the option to not map this field. If you want to map this field, use the drop-down to select which Solid Commerce field you want to map this data You will want to reference the value in CUSTOM FIELD (to the right) to know which field you are mapping.
  2. CUSTOM FIELD: This field is auto-populated based off the columns detected in the file you You will use this as reference for mapping in the previous step.
  3. SAMPLE DATA: This field is auto-populated with the data from the first row of file for column You will use this as reference for determining the remaining details.
  4. DEFAULT VALUE: You can enter a default value into this field, IF it will apply .all the items in your file
    • example: If you selected upload inventory on the previous page, you will need to add the warehouse name. You can use a default value with the name of the warehouse you will be uploading this information to.
  5. EXPRESSION: If you are in need of using expressions to calculate or convert values, please contact your Growth Advisor. You will want to leave this field blank for now.
  6. DATA TYPE: Use the drop-down to select the type of data the values for this column will be formatted as.
    • For things such as UPC, Sku, Product Name, Description, you most likely will use Text
    • For things such as Quantity, Product Weight, Product Height, etc, you will use Integer.
    • If you need assistance with determining the data type, please work with your Growth Advisor.

Once you have completed the mapping, you have two save options:

  1. SAVE - Selecting this option will save the template for future uploads, however, will not upload the file you selected for the mapping.
  2. SAVE AND IMPORT - Selecting this option will save the template for future uploads and will upload the file you selected for the
    • This option will bring you to a new page, letting you know your file was successfully uploaded into the queue
      • To view the progress and result of the file upload, navigate to Reports> Inventory Imports Status
      • Use the drop-down for Filter Import Status and select All Imports> click SEARCH

SC.jpg

Was this article helpful?
2 out of 2 found this helpful
Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.