This article includes information about a few of our data templates that may be ingested via SFTP.
NOTE: These templates are only applicable to Manufacturers that have an Elite subscription and an Inbound Data Feed subscription, or an Agency with an Inbound Data Feed subscription.
For more information about these subscriptions, complete one of the forms for Elite or Inbound Data and our Sales team will reach out!
Products via SFTP
The template linked below is our comprehensive import template to automate products into MarketTime on a regular cadence.
https://s3.us-east-2.amazonaws.com/markettime-prod-support-docs/40.xlsx
Things to Know
- When supplying this file for pickup by MarketTime, the file name must be consistent and named according to your MarketTime account's unique ID (e.g. M1234_items.xlsx).
- Only the column headers and your data should remain on each sheet you provide. Be sure to remove the informational rows 2-4 from the template linked above.
- You only need to include the tabs of the file you intend to load at any given time. (e.g. only providing the ItemImage tab in the file if loading/updating product images, or the Item tab if updating general item information). These can be used in any combination as desired.
- The tabs you include in the file must be named the same as they appear in the template linked above.
- Using the recordDeleted column on each tab will allow you to remove the corresponding row from MarketTime by setting the value to TRUE. It can be brought back by simply switching it back to FALSE.
- As noted within the template, you may utilize either your product's itemNumber, or a corresponding externalID value for the desired record. The only exception is when the item is first being introduced into MarketTime, which requires both to ensure your externalID is associated with the correct record. Going forward, you can reference the data with your externalID value.
Last updated: