A customer managing a complex product catalog reached out with a question: "I need to create an export that includes retail price, internal product name, and supplier. But it appears this information is spread across two databases."
The customer required a clear and efficient method to combine this data into a single export file without manual errors or complications.
The osCommerce support team provided a step-by-step approach to address the challenge:
.jpg)
- Export Retail Price and Internal Product Name: Use the Products file export, where these fields are readily available.
- Export Supplier Information: Choose either the Supplier Products file (showing the relationship between suppliers and products) or the Suppliers file (listing all suppliers).
- Combine Files: Once both exports are complete, merge the required data into a single file using a spreadsheet tool or similar software to create the desired output.
This practical solution empowers users to efficiently handle and customize exports across multiple databases, and provides a complete dataset, including retail prices, product names, and supplier details.
