Success Story: Simplifying Product Exports Across Multiple Databases

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:

• 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.