How to prepare your product list for bulk upload into the Micromart Platform
Preparing your itemized product list is an efficient way to bulk upload the products, pricing and pictures of each of the products that you'd like to sell across all of your Micromart Smart Stores.
In the provided spreadsheet template, fill in each line for every product you plan to sell in your Micromart stores. Here is what all of the columns mean:
- Product Display Name: The name of the product as it will appear on the display and in the customer interface.
- Size (value): The quantity or volume of the product (e.g., 500 for a 500ml bottle).
- Size Unit (oz, g, each): The unit of measurement for the product (e.g., ounces, grams, or each for individual items).
- UPC (12 characters, if available): The Universal Product Code, a unique barcode identifier, if applicable.
- Cost (if available): The cost of purchasing the product from your supplier.
- Price (before tax): The price you plan to sell the product, excluding tax.
- Tax Rate: The percentage of tax applicable to the product.
- Note: prices in the Micromart system are inclusive of applicable taxes
- Price (tax included): The final price the customer will pay, including tax.
- Category: The type of product (e.g., drink, snack, non-food) to help organize items in your store.
- Product Purchasing Link: A link to the product from your supplier or an image link to show what the product looks like.
- Custom Tag: Any specific tags or notes for internal categorization or differentiation. (eg: candy, protein-bar, energy-drink, soda, sparking-water, vegan, gluten-free). Tags can be used for a variety of purposes including:
- Advanced data analytics: Run reports to see how items tagged as "energy-drink" perform against "sports-drink"
- Promotions: Easily run a promotion on a specific product category. For example, on Halloween, you can easily run a 20% OFF on all items tagged as "candy".
-
- Tax reporting: tag products that may have tax treatment (eg soda-tax) to make tax reporting easier.
- Notes: Additional information or details about the product that may be relevant.
- Max Capacity: Micromart will complete this field based on the product and shelf/pusher configuration.
Please ensure all fields are completed. This information is critical for setting up your store correctly and ensuring accurate inventory management.
Once completed, kindly send it to support@micromart.com, and we will start uploading it into the Platform for you. If we have comments about your product list, we will share a Google spreadsheet with you with those comments.