Learn which Import / Export spreadsheet will best suit your needs for bulk changes in Listing Mirror
Import / Export spreadsheets are the ultimate tool for efficiently managing data in large quantities. They offer a wide range of capabilities, from modifying marketplace-specific fields and updating category-specific information to creating products and listings, and so much more!
You can find the Import / Export spreadsheets under Reports on the menu bar.
Before uploading a spreadsheet
To ensure successful upload of the spreadsheets you download, it is important to follow the given guidelines. Failure to adhere to these guidelines may cause the spreadsheet to time out, fail to upload, or even result in data loss.
- Do not adjust the columns.
- Do not adjust the headers.
- Do not adjust the ordering of SKUs where variations are involved.
- Do not fill in parent cells where the sheet is gray.
- Do not change the file type.
- Do not leave formulas in the cells. Use special paste to remove them.
If you encounter any issues with your spreadsheet, such as unknown errors or timeouts, we suggest uploading it with a smaller amount of data. This will make it easier to identify and troubleshoot any problems that may be occurring with your spreadsheet.
If you encounter any errors during the upload process, you have the option to review your notification center and download a sheet that provides a detailed explanation of the errors.
Understanding the purpose of each spreadsheet
Amazon Add Offers
The Amazon Add Offers spreadsheet provides you with the capability to add offers to your existing Amazon listings by matching ASIN, UPC, EAN, or ISBN. Simply complete all the required fields, and our system will send it to Amazon for approval. Learn more
Category Specific Add/Update
The Category Specific Add/Update spreadsheet enables you to modify the category-specific data linked to your listings. Additionally, if the marketplace supports it, you have the option to add custom category-specific fields. Learn more (coming soon)
The Component Location spreadsheet enables you to easily update the locations of your products that are part of a component based on your inventory source. Learn more (coming soon)
Component Quantity Update
The Component Quantity Update spreadsheet provides users with the ability to easily update the quantity of products that are part of a component. Learn more (coming soon)
The Components Edit spreadsheet provides you with the ability to modify basic information about your component, such as its title and cost. It is important to note that any changes made in this spreadsheet will only impact the component itself and will not be reflected in any associated listings or product data. Learn more (coming soon)
Create and Delete
The Create and Delete spreadsheet provides you with the functionality to create, delete, and view listings that are present in a particular marketplace. Additionally, it allows you to delete complete products and their associated listings. Learn more
Edit SKU Level Inventory
The Edit SKU Level Inventory spreadsheet provides you with the ability to selectively include or exclude inventory sources for a specific marketplace on a SKU level basis, instead of modifying the entire marketplace. Learn more (coming soon)
Export Listing Status
The Export Listing Status spreadsheet offers you a comprehensive export of general data for your listings. This includes any errors, warnings, or informational messages that may be present. Additionally, it provides you with the total quantity for each listing, giving you a complete overview of your inventory.
Future Dated Inventory
The Future Dated Inventory spreadsheet enables you to keep track of the inventory that is scheduled to arrive from different sources. Simply fill in the details of the incoming inventory for a specific source on a specific date. Learn more (coming soon)
The Images Edit spreadsheet provides users with the ability to easily upload images from a public URL to their listings on a specific marketplace. This spreadsheet is particularly useful for those who require specific images for a particular marketplace. Learn more (coming soon)
The Inventory Location spreadsheet enables you to easily update the locations of your products based on your inventory source. Learn more (coming soon)
Kit Missing Recipes
The Kit Missing Recipes spreadsheet provides a comprehensive list of components that currently do not have any connections to a kit or a bundle. Additionally, you have the flexibility to create your own kits, bundles, or shadow inventory by utilizing the additional columns available in the spreadsheet. Learn more (coming soon)
The Kit Recipes spreadsheet presents you with a comprehensive list of all your products along with their associated components. Additionally, you have the capability to create kits, bundles, and display inventory using the additional columns provided. Learn more (coming soon)
The Link Listings spreadsheet provides you with the ability to connect listings that are associated with one product to another product. This is particularly useful when you have two different SKUs on a marketplace during an import. It is essential to link your listings under the same product to maintain synchronization in your inventory. Learn more (coming soon)
Market Listing Add
The Market Listing Add spreadsheet enables you to easily create listings for a specific marketplace by selecting a specific marketplace category. Simply fill in the necessary listing and category-specific details to publish your listings. This will automatically generate an associated product for your Product Catalog using the provided listing details. Learn more (coming soon)
Market Listing Complete Edit
The Market Listing Complete Edit spreadsheet provides you with the capability to make edits to every aspect of a listing. This includes both the listing details and category information. Simply choose a marketplace and category that you would like to modify, and proceed to make changes to all the listings that belong to that category. Learn more (coming soon)
Market Listing Core Edit
The Market Listing Core Edit spreadsheet provides the capability to modify the core components of your listing details. With this spreadsheet, you can easily update specific fields, such as the description, if you need different data for a particular marketplace. This is ideal for customizing listing details to increase sales. Additionally, it allows you to edit marketplace-specific fields, like Shopify's “URL Handle” field or Walmart's “Shipping Profile” field. Learn more
Missing Category Specific
The Missing Category Specific spreadsheet provides you with the ability to download and view all category-specific fields that are currently missing on a specific marketplace. This is a valuable tool for resolving any errors related to category-specific data, giving you the opportunity to input the necessary information as required. Learn more (coming soon)
The Price Update spreadsheet provides a convenient way to update the prices of your listings in bulk. This spreadsheet is ideal if you need to adjust the prices of your listings specifically, allowing you to set different prices for each marketplace. Learn more
The Product Add spreadsheet enables you to effortlessly add new products to your Product Catalog. This spreadsheet empowers you to create products and input all the necessary general information before proceeding to create listings on each marketplace. You'll have the ability to fill in common fields such as LMSKU, Title, Description, Bullet Points, Images, Price, and more. Learn more
The Product Edit spreadsheet provides you with the ability to easily modify your existing products in your Product Catalog. This spreadsheet allows you to efficiently manage your product data by updating general information in one centralized location. You can conveniently edit common fields such as LMSKU, Title, Description, Bullet Points, Images, Price, and more. Learn more
Quantity and Location Update
The Quantity (and Location) Update spreadsheet provides you with the capability to easily update the quantity of your non-3PL products, as well as specify a custom location where the quantity is located. Learn more
The Tracking Data spreadsheet provides you with the capability to efficiently manage the tracking data for your orders. You can easily add the Listing Mirror order number, carrier, and tracking data to apply them to your orders. Learn more (coming soon)
Untracked Listing Add
The Untracked Listing Add spreadsheet enables you to add listings in bulk using Amazon listing data without the need to create listings on Amazon. This is especially useful if you do not have permission to sell a particular item on Amazon, but still want to utilize the listing data for other purposes. Learn more (coming soon)
The Vendor Catalog spreadsheet provides you with the ability to easily access and manage your SKU information that is linked to a specific vendor. Furthermore, you have the option to effortlessly add new items to your vendor catalog by completing the designated columns. Learn more (coming soon)
Walmart Add Offers
The Walmart Add Offers spreadsheet provides you with the capability to add offers to your existing Walmart listings by matching a UPC, GTIN, EAN, or ISBN. Simply complete all the required fields, and our system will send it to Amazon for approval. Learn more (coming soon)