Coronado DC is a leading distributor in the US of a wide variety of tactical apparel, footwear, custom ceremonial gear and equipment, shipboard parts, office supplies, and more. Partnered with leading manufacturers and most popular brands, they provide a comprehensive inventory of products.

Coronado DC had its eCommerce platform built upon the robust BigCommerce and were using P21 to manage their backend activities seamlessly. Apart from the mentioned two, they also integrated a modern product information management solution, DCKAP PIM, to manage and maintain their data at all the touchpoints.

However, a prime issue they were encountering was the Product Sync where they had more than 300,000 SKUs that had to be migrated without any data loss at any end. And also wanted to connect their data points which would sync the details of customers, products, orders, prices, and more, between eCommerce and ERP.

Coronado DC faced difficulty syncing data from P21 to BigCommerce. The P21 data format did not match with the BigCommerce format which led to increased manual efforts. Multiple vendors had multiple data formats making it difficult to import data each time. Syncing multiple vendor data to Bigcommerce was getting lagged while time and money were being spent on repetitive tasks. These manual efforts were prone to errors and having no system in place to identify and correct them, made the job more challenging.

The team at DCKAP Integrator wanted to provide an effective business solution so the company can focus on achieving its dreams while our connectors align the data between ERP and eCommerce. Check out what we delivered:

1. Customer Sync: BigCommerce > P21
2. Products Sync: PIM > P21 & PIM > BigCommerce
3. Order Sync: BigCommerce > P21
4. Order Processing Sync: P21 > BigCommerce
5. Offline Orders Sync: P21 > BigCommerce
6. Pricing Sync: P21 > BigCommerce
7. Offline Quotes Sync: P21 > BigCommerce
8. AR Invoice Sync: P21 > BigCommerce

Data silos present a large problem that will likely require some significant shifts, but there are some initial steps with the help of integrations that DCKAP Integrator took to tackle this problem faced by CoronadoDC. The integrations by DCKAP Integrator assure all the data pertaining right from customers and orders until the consignment is reached, is stored safely in the backend, and sent to all the key areas where the data is needed. Beyond taking and placing the data at integrated points, the stakeholders can use this real-time data to make informed business decisions and improve the efficiency of their organization.

Coronado DC has more governance over product data with a single repository to manage it. DCKAP PIM identifies the product edits made within P21 and adapts it to the BigCommerce format for publishing, without manual intervention.

Custom imports helped them create reusable templates to import multiple data formats from different vendors. DCKAP PIM also shows exceptions in data quality upfront making the process error-free and time-saving. With user management, Coronado DC has full control over who gets to access what data within DCKAP PIM.