MarketTime allows you to upload your items for use by sales agencies utilizing MarketTime as their order writing platform.
MarketTime Product Import Template
Importing Items via Excel sheet
Begin by clicking on the Items button on the left side of the screen, and click the Import/Export option.
Video Overview
To import new products, click the Import Items button in the Import section of the screen:
Template
MarketTime recommends that you use the template provided or reference the template when creating your file and before uploading. The template, linked HERE and at the top of this article provides instructions for formatting each column as well as which columns are critical and the implications for not filling out certain columns.
Choose the File
Here you will choose to browse for your Excel file with product data in it, by clicking the Choose button and searching your computer for the desired product file.
Map Data Columns
Once selected, you will need to match the columns within the Excel sheet with what MarketTime will expect those columns to contain, to ensure the data imports correctly.
Do this by using the drop-down menus by the items with the red X next to them, which notates that they were not automatically matched.
Any columns left unmatched will not be imported
To match a column, click the drop-down button and match your column with the expected column. You can also search for the field name in the search bar:
Now that all the data has been properly matched, and all columns have check-marks next to them, click the Next button to move to the next step!
The next screen allows you to view your data to ensure it’s correct, and make any last-minute alterations if need.
If the data is correct, click the Next button to progress to the next step!
Final Steps
On the final screen, is where you have a few additional options to choose from before importing your data.
If this is your first item import in MarketTime, it does not matter which option you choose, but for future imports, it's important to know that if you choose one of the REPLACE options, it will completely replace what's currently in MarketTime while importing, see below for more info.
- Replace Items will remove all items from MarketTime and replace them with the items in the file you're uploading during this process.
- Replace SCS will remove all Size, Color, Style product variants in MarketTime and replace them with what's in the file you're uploading during this process.
Neither of these options can be undone, so ensure it's the intent to remove the data from MarketTime and replace with the data you're importing before proceeding.
If you choose no options and simply click Import Items, MarketTime will attempt to import your file, and make necessary changes.
- Items that exist on your file and in MarketTime will be reviewed and updated if changes are found.
- Items that exist on your file but not in MarketTime will be added alongside the existing items in the system.
If there are any errors during the process, you will be notified, and be given the ability to view the error file.
Once the process has successfully completed, you will be taken to your product list, on the View Items tab.