Business Challenge
VB Cosmetics, Inc., maker of the Dazzle Dry® nail care system (dazzledry.com), sought to expand its digital sales channels without adding back-office complexity. As Amazon became a rapidly growing sales channel, the company needed a way to automatically capture orders from Amazon’s Fulfillment by Amazon (FBA) system and integrate them into SYSPRO ERP—without manual rekeying or processing delays.
VB Cosmetics’ main goals included:
- Automate sales order creation from Amazon to SYSPRO
- Eliminate manual reconciliation of orders and invoices
- Ensure automatic alignment between order processing and financial records
- Create a scalable integration framework to support e-commerce growth
Technology Challenges
As Amazon sales increased, VB Cosmetics’ manual processes created several operational bottlenecks:
- Manual Order Entry: Staff had to re-enter FBA orders into SYSPRO, leading to delays and errors.
- Delayed Invoicing: Without automation, invoices lagged behind order fulfillment.
- Restricted Data: Amazon’s limited customer data access required careful mapping and handling.
- Scalability Risks: Manual workflows could not keep up with seasonal spikes or sustained growth.
The Magic Solution
VB Cosmetics turned to Magic Software to automate its Amazon-to-SYSPRO workflow using Magic xpi Integration Platform. Leveraging Magic xpi’s prebuilt connectors and low-code framework, Magic implemented a robust solution that:
- Retrieves Amazon FBA reports and automatically creates corresponding sales orders in SYSPRO as “Open Orders”
- Assigns all orders to a dedicated “Amazon” customer account for simplified processing
- Automates A/R invoice creation and payment posting after each sales order
- Includes structured error-handling and email notifications for immediate visibility
- Runs on a predefined schedule to maintain near real-time synchronization
By automating the entire process, Magic eliminated manual bottlenecks and improved data accuracy, creating a reliable and scalable integration framework for VB Cosmetics’ e-commerce operations.
“VB Cosmetics has been rapidly expanding our channel outlets, and Amazon was key to unlocking new opportunities. The Magic Integration team was incredibly supportive and flexible, quickly adapting to our fast-paced environment while developing and resolving any issues that arose.”
— Bijan Dosi, Project Manager, VB Cosmetics
Results
VB Cosmetics achieved measurable improvements across key operational areas:
- End-to-End Automation: Orders flow seamlessly from Amazon FBA to SYSPRO—no manual entry or reconciliation.
- Faster Order-to-Invoice: Automated invoicing and payment postings shorten the cash-to-collection cycle.
- Improved Data Accuracy: Standardized mappings and automated error handling ensure clean data across systems.
- Near Real-Time Sync: Scheduled workflows keep Amazon and SYSPRO continuously aligned.
- Increased Efficiency: Staff time is redirected from manual entry to high-value business activities.
- Future-Ready Scalability: The framework supports growth, new product lines, and seasonal surges.
Conclusion
With Amazon and SYSPRO now working in sync, VB Cosmetics has built a strong, scalable foundation for continued e-commerce growth. The automation achieved with Magic xpi has streamlined operations, reduced manual errors, and empowered the company to focus on expanding its market presence with confidence.
Looking to simplify and connect your own systems? Contact us to learn how Magic Software can help you integrate your business applications with ease.
