You can utilize the grid in Merchant Center to customize your exports, ensuring you receive the specific information you need.
Most views in Merchant Center allows you to export data whether it's products, categories, brands, properties, customers, subscribers, orders and refunds etc.
For all of these you are given two options, either Export all or Export this.
Export all means that all the data and columns will be exported to a .csv file while Export this means that all the columns which is visuable and all the filters made will be exported to a .csv file.
Under Products there is a third option where there is a checkbox called Include items in export meaning all the items (sizes) will also be included in the .csv file.
The additional columns which will be included in the .csv file is:-
ProductItemId: A unique identifier for each product item in the inventory.
-
SizeArticleNumber: A specific identifier that combines both the product and its size variant, enabling unique identification of inventory items that differ only in size.
-
Size: The size of the product, which can be crucial for apparel, footwear, and other products where size is a significant variant. This could be numerical (e.g., 8, 10, 12) or descriptive (e.g., S, M, L).
-
StockThreshold: A set point that triggers a notificationwhen the stock level falls to or below this number. It's used to alert administrators to restock to prevent stockouts.
-
StaticStock: The number of units of a product item that are consistently available. This refer to a baseline stock level that is maintained at all times, not accounting for fluctuations due to sales or restocking.
-
OversellableStock: The quantity of a product that can be sold even if it exceeds the actual stock available.
-
Shelf: The specific location within a warehouse or storage area where the product is stored. This could be an alphanumeric code indicating a shelf number, facilitating easy retrieval.
-
ItemWeight: The weight of the individual item, typically measured in kilograms or pounds. This is essential for shipping cost calculations and logistics planning.
-
ItemHeight: The height of the item, usually measured in centimeters or inches. This dimension is crucial for determining the packaging and shipping requirements.
-
ItemWidth: The width of the item, also measured in centimeters or inches, contributing to understanding the space it occupies for storage and shipping.
-
ItemLength: The length of the item, measured in similar units to height and width. Together with height and width, this defines the product's dimensional space.