How to Structure Your Product Data for Migration/Import

Last updated August 21, 2025

Migrating your product data into the Afya X system via the Mio App platform is a crucial step that ensures your customers have access to accurate, reliable, and industry-compliant information when making purchase decisions. To make the process seamless, we provide an Excel template that standardizes how product data should be filled. Below is a detailed guide on how to correctly structure your product information:

1. Brand

Enter the product's official brand name as marketed. This helps customers easily identify and differentiate between multiple manufacturers offering similar products.

2. Generic Name

Provide the generic or scientific name of the drug/product. This ensures compliance with health industry standards and supports healthcare professionals in making safe recommendations.

3. Category

Classify each product into its appropriate category (e.g., Antibiotics, Pain Relief, Nutritional Supplements). Proper categorization makes it easier for customers to search and compare products.

4. Formulation

Indicate the product's form - whether it's a tablet, capsule, syrup, ointment, or injection. This details allows customers and practitioners to match the product to the right treatment method.

5. Strength

Specify the dosage strength (e.g., 500mg, 250mg/5ml). Accuracy here is critical for safe dosage and treatment compliance.

6. Pack Size

Enter the number of units per pack (e.g., 10 tablets per strip, 100ml bottle). This helps in pricing transparency and inventory control.

7. Quantity in Stock

Record the available stock levels to ensure your inventory is up-to-date. This prevents overselling and stock outs while giving customers real-time availability.

8. Buying Price

Input the cost at which you purchased the product. This is necessary for internal records, profit margin tracking, and accounting.

9. Selling Price

Provide the retail price. Accurate pricing ensures fair competition and builds customer trust.

10. Expiry Date

Clearly state the product's expiry date. This is mandatory for compliance with pharmaceutical standards and protects customers from consuming expired products.

11. Batch Number

Enter the batch number as provided by the manufacturer. This is essential for quality assurance, product tracking, and recalls if necessary.

12. Supplier

Document the name of the supplier. This strengthens supply chain traceability and accountability.


Why Proper Structuring Matters

  • Compliance: Aligns with pharmaceutical and healthcare regulations.
  • Transparency: Builds customer trust with accurate and visible product details.
  • Efficiency: Streamlines data import and reduces errors during migration.
  • Decision-Making: Equips customers with all the critical details
  • Accountability: Enhances tracking, auditing, and recall management.

By carefully filling in each field as outlined, you ensure that your products are correctly displayed in the Afya X marketplace, improving discoverability, compliance, and customer satisfaction.

Managing Stock on the Mio Admin Platform
Read More
Managing Orders on the Mio Admin Platform
Read More