How to Create Products in Bulk on Makro Marketplace – Full Guide
Creating products in bulk is an efficient way to list large quantities of items within the same vertical on the Makro Seller Portal. This guide walks you through the process of downloading, completing, submitting loadsheets, reviewing the submission status, and addressing any errors.
Part 1: Downloading, Completing, and Submitting Loadsheets
Step 1: Navigate to the Bulk Product Creation Page
- Go to Listings: In your Seller Portal, navigate to Listings > Bulk Product Creation.
- Select "Create Product": Click on the "Create Product" button.
- Choose the Correct Vertical: Use the dropdown menu to select the correct vertical for your products. Be cautious when searching, as vertical names often contain underscores. Try variations if needed.
- Download the Excel File: After selecting the appropriate vertical, click "Download". This will download the bulk upload template (loadsheets) specific to that vertical.
Step 2: Prepare the Loadsheets File
- Do Not Rename the File: The file must remain with the exact name as downloaded to avoid errors during the upload process.
- Ensure You Are Using a Valid Excel License: Work on a device with a valid Microsoft/Excel license to avoid issues.
- Headers Cannot Be Edited: The headers in the Excel file cannot be edited. Attempts to edit rows 1 - 4 will prompt an error message. Row 5 downwards are editable cells.
- Review the Information in the Excel File:
- Row 1: Lists the headings for each column, showing what information is needed.
- Row 2: Specifies the required format for each field.
- Row 3: Provides example input for each field.
- Row 4: Describes the required information for each field.
Step 3: Input Product Information
- Go to the Vertical Tab: Navigate to the tab labeled with your vertical name to input product data.
- Input Information from Row 5 Onwards: Start entering your product data from row 5. You can add up to 1000 products per vertical in one loadsheet.
- Required Information: Columns with blue headers are mandatory. These fields must be filled out.
- Optional Information: Columns with green headers are optional and can be filled out if relevant.
Step 4: Formatting Requirements
- Single Text Fields: If the header in row 2 is hyperlinked with “Single Text – click here to get allowed values,” you must select one of the allowed options from the dropdown.
- Multi-Text Fields: If the header is hyperlinked with “Multi Text – click here to get allowed values,” use the predefined values (in the index tab) and separate multiple values with "::" or "||".
- Product Images: Use Google Drive links for product images. Make sure the folder’s sharing settings are public, and paste the public link into the relevant cell in the Excel file.
Step 5: Save and Upload the File
- Save the File: After filling out the information, save the file without renaming it.
- Return to the Seller Portal: Go back to the Bulk Product Creation page.
- Upload the File: Click "Upload" and select the saved file to upload it. The system will begin processing it.
Important Callout: If there’s an issue with the file format or file name, the system will show an error during submission.
Step 6: Monitor the Submission Status
- Check Submission Status: After uploading, monitor the status of the submission in the Bulk Product Creation page’s status table.
- Feedback Time: Feedback may take up to 3 business days. Review any issues and make necessary corrections once feedback is provided.
Part 2: Reviewing Status, Downloading and Resubmitting the Failed Loadsheet
Step 1: Understand the Three File QC Statuses
- QC Passed: All products passed QC and will appear in My Listings within 24 hours.
- QC Failed: If at least one product failed, you must address the error(s) and resubmit the file for the products that failed. Passed products will be added to My Listings.
- QC In Progress: Products are still under review. Wait for the QC process to complete for all products.
Step 2: Review the Status Table
The status table will show how many products have:
- QC Passed: These products have been successfully created.
- QC In Progress: Products still under review.
- QC Failed: Products with errors that need action. Download the failed file and correct the errors.
Step 3: Download the Failed File
- Go to the Submission Status Table: Locate your submission.
- Click "View": Under the Actions column, click "View" next to your submission.
- Click "View QC Status": Click this to see the detailed QC status.
- Click "Correct Errors": This will start the error correction process.
- Request the Failed File: Click "Request" to generate the failed file and then click "Last requested file" to download it.
Step 4: Understanding the Failed File
- Locate the Error Reasons: Column C of the vertical tab will list the reasons for failure.
- Highlighting in Red: Red cells indicate errors. Hover over the red cells to view the explanation of the error in a comment.
- Make Corrections: Correct the highlighted issues based on the error messages.
Step 5: Resubmitting the Corrected File
- Save the File: After corrections, save the file without renaming it. It must have the same name as the original failed file.
- Go to the Portal: Navigate back to the Bulk Product Creation page.
- Upload the Corrected File: Click "Upload", attach the corrected file, and resubmit it.
Conclusion
By following these steps for creating, monitoring, and correcting bulk product listings, you can efficiently manage large quantities of products on the Makro Marketplace. Attention to detail during the preparation and error correction stages will ensure smooth submission and improve your chances of successful product creation.