mindwerks

Cross-Border E-Commerce — Managing 50+ Vendors and Hazmat Compliance Across Borders

From weeks-long vendor onboarding and manual hazmat paperwork to automated product pipelines across borders

Multi-CountryDirect-to-ConsumerVendor OnboardingHazmat Compliance
DjangoPythonShopifyPostgreSQLQuickBooks
50+Vendor Feeds Automated
80%Faster Vendor Onboarding
4xFaster Catalog Updates
100%Hazmat Shipping Compliance
← All Experience

Context

A general merchandise and beauty products reseller was expanding its cross-border e-commerce operation — selling perfumes, cosmetics, electronics, and household goods through Shopify across multiple countries. The catalog was sourced from dozens of third-party vendors, each with different data formats and update frequencies. Adding new products meant manually downloading spreadsheets, reformatting data, and uploading to Shopify — a bottleneck that slowed catalog growth.

Dozens of vendors, each with different data formats — and a growing catalog of regulated items requiring hazmat declarations for every international shipment.

Complicating things further, a significant portion of the catalog included regulated items: perfumes classified as flammable liquids, electronics containing lithium batteries, and aerosol products. Each required specific hazardous materials declarations for international shipping — requirements the team was handling manually and inconsistently.

Vendor Data SourcesAPIsReal-time product feedsExcel / CSVScheduled file dropsWeb PortalsAuthorized extractionShopifyStorefront & OrdersMulti-country, multi-languageCentral Operations HubOperations HubVendor Data ProcessingAutomatic PricingProduct CatalogWarehouse & FulfillmentHazmat ComplianceQuickBooksAccounting & COGSScheduled syncShippingLabels & TrackingHazmat carrier routingExchange RatesLive currency conversion

Challenges

  • Vendor data arrived in wildly different formats — some vendors offered digital feeds, others sent weekly Excel files via email, and a few only had web portals with no export option. There was no unified way to get all this product data into the catalog.
  • Perfumes, aerosols, and electronics with lithium batteries required hazardous materials classifications and shipping declarations that varied by carrier and destination country. Getting these wrong meant shipments rejected at customs, returned at the seller's expense, or regulatory fines.
  • Pricing across countries required calculating from vendor costs through currency conversion, tariffs, and margin targets — but vendor cost data itself was inconsistent, arriving in different currencies and units across feeds.
  • The catalog was growing faster than the team could manually process. New vendor onboarding took weeks of back-and-forth to map their data into the right format, delaying time-to-market for new products.
  • Shipping hazmat items required special carrier services and packaging declarations that the existing manual workflow couldn't reliably handle at scale.

Solution

We built a custom operations platform with an automated vendor pipeline and hazmat compliance engine — giving the team a single system to manage vendors, products, pricing, and fulfillment across all target markets.

Automated Vendor Onboarding

Vendor data arrives in every format imaginable — digital feeds, spreadsheets, web portals. The system normalizes it all into one product catalog automatically. Configurable field mappings mean new vendors go from signed contract to live products in days instead of weeks.

Hazmat Classification & Compliance

Products like perfumes, lithium batteries, and aerosols are automatically flagged and classified with the correct hazardous materials documentation for each carrier and destination. Every regulated shipment leaves with the right paperwork — no manual declarations, no customs rejections.

Automatic Pricing & Catalog Updates

Vendor costs in different currencies are normalized, then pricing is calculated automatically with live exchange rates, country-specific tariffs, and configurable margin targets. Updated prices and localized product data sync to the storefront without manual intervention.

Fulfillment & Hazmat Routing

Hazmat items are automatically routed to carriers and service levels that accept dangerous goods — the right service, the right documentation, no manual intervention. Standard items flow through the same integrated workflow with barcode scanning, label generation, and automatic tracking updates.

50+ vendor feeds across digital sources, spreadsheets, and web portals — all normalized into one catalog, with new vendors onboarded in days instead of weeks.

BeforeVendor EmailsExcel attachmentsWeb PortalsCopy-paste dataAPIsUnusedManual ReformattingSpreadsheets, field mapping by handShopifyHazmat GuessworkManual declarationsManual vendor processing, hazmat errorsWeeks to onboard vendors, customs rejectionsAfterVendor FeedsAPIs + Excel + Web PortalsOperations HubVendor PipelinePricing EngineCatalog & FulfillmentHazmat ComplianceShopifyShippingQuickBooksFX RatesAutomated pipeline, compliant shippingDays to onboard vendors, zero customs issues

Results

50+Vendor Feeds

Automated ingestion from APIs, Excel file transformations, and authorized web portal extraction into a single normalized pipeline.

100%Hazmat Compliance

Every regulated shipment — perfumes, lithium batteries, aerosols — left with correct hazardous materials declarations per carrier and destination.

4xFaster Catalog Updates

New products from vendor feeds appeared in the storefront in hours instead of days, with pricing calculated automatically across all markets.

80%Faster Vendor Onboarding

Configurable field mappings reduced new vendor integration from weeks to days.

0Customs Rejections

Eliminated shipment rejections and regulatory fines from incorrect or missing hazmat documentation.

Facing a Similar Challenge?

Every business has unique operational needs. Let's talk about yours and explore how a custom solution can help.