Celigo ShipHero Acumatica Integration Case Study: Brandito
Industry: Promotional Products and Branded Merchandise
Core Tech Stack: Celigo, Acumatica, ShipHero, BigCommerce & BrightStores
Scope: Celigo Order-to-Cash Integration, Tax and Accounting Mapping, Order Exception Handling, Goods Receipt Sync, Inventory and Product Sync, QA and Launch Support
How Brandito connected two storefront platforms to Acumatica and ShipHero on Celigo, with orders running from checkout to a closed invoice and tracking back to the store
About Brandito
Brandito is a promotional products company in Richmond, Virginia, with teams in Cincinnati and New Jersey. Its services span promotional products, online stores, uniform solutions, and warehousing and logistics. Brandito runs branded online stores for its customers, including a store on BigCommerce and a store on BrightStores, both fulfilled from one ShipHero warehouse and accounted for in Acumatica. Brandito partnered with Snapshot to connect both storefront platforms to its Acumatica ERP and ShipHero warehouse on Celigo, so products, orders, shipments, and invoices move through one integration.
Project Overview
Brandito’s storefronts sent orders directly to ShipHero, and Brandito’s team batch-imported them into Acumatica after the fact. Brandito wanted one integration layer with Acumatica at the center of its online stores. In Brandito’s setup, the two storefront platforms also handle tax, payments, and gift certificates differently. Accounting needed every order, payment, refund, and tax line booked to the right branch and general ledger account, with tax reaching Avalara only once.
Brandito partnered with Snapshot to build the integration on Celigo. Snapshot built flows for orders, inventory, and products across both storefront platforms. Every store now connects through Acumatica, and no store sends orders to ShipHero directly. Orders now flow into Acumatica, shipments and invoices flow out, and tracking returns to the customer.
The Solution
Order-to-Cash Flows
Snapshot built 16 Celigo order-to-cash flows that carry each order from checkout to a closed invoice. When a customer checks out on either storefront, Celigo creates an Acumatica sales order, records the payment as an Acumatica prepayment with the storefront transaction ID, and sends the order to ShipHero. Each ShipHero shipment posts against the Acumatica sales order, including partial shipments, split shipments, and gift-card-only orders. At shipment, Celigo creates the invoice in Acumatica, closes it, and writes tracking back to the store.
Accounting and Tax Accuracy
Celigo posts each order to the correct Acumatica branch and general ledger account. Both storefronts send tax to Avalara directly, so Snapshot mapped each order to a storefront tax zone that prevents Avalara from receiving the same tax twice. For BrightStores orders, Celigo maps line tax to the general ledger by ship-to state, and Acumatica records tax exactly as the storefront charged it.
Celigo posts gift certificates as a non-stock item to each store’s liability account. When a customer pays with a gift certificate and a card, Celigo records two Acumatica payments on the order. Each Acumatica order number combines the customer and the store order number, so order numbers stay distinct across stores.
Order Exceptions
Snapshot built Celigo flows for these order exceptions:
- Partial and split shipments: Celigo posts each shipment against the original Acumatica sales order.
- Back orders: When ShipHero shows nothing left to ship, Celigo closes the remaining quantity in Acumatica and refunds the unbilled amount.
- Short ships: Warehouse staff edit the quantity in ShipHero. Celigo completes the order and refunds the difference against the prepayment.
- Cancellations: A cancellation can start in the storefront or in ShipHero. Either way, Celigo reverses the payment first, cancels the order in both systems, and creates the refund.
- Refunds: Celigo applies each customer refund to the prepayment and releases it.
- Reships: Celigo posts a reship as a second shipment on the original order and records an inventory adjustment in Acumatica for the reshipped goods.
- Returns: Warehouse staff create the return in ShipHero and receive the goods against it. Celigo then books a return order, a receipt, a credit memo, and a refund in Acumatica. Refunds go to the original card, or to the customer’s account balance for BrightStores orders.
Inventory and Product Sync
Celigo posts ShipHero goods receipts for both stores into Acumatica, replacing a weekly upload. Inventory corrections also post to Acumatica automatically. When a product is added or changed in a storefront, Celigo creates or updates it in Acumatica and ShipHero with its sizes and up to three images.
The Impact: One Integration Layer from Checkout to Closed Invoice
In its first week live, the integration:
- Processed 41 orders (967 units) from the BigCommerce and BrightStores stores
- Posted 40 shipments (922 units) to Acumatica and wrote tracking for each back to the store
- Recorded 41 customer payments
- Booked 2 warehouse receipts (1,018 units) into Acumatica
- Updated 606 items in Acumatica and ShipHero through the product sync
- Ran on 24 Celigo flows across orders, goods receipts, inventory, and products
In that first week, orders posted to the correct branch and general ledger account, Acumatica recorded BrightStores tax as the storefront charged it, and no tax was submitted to Avalara a second time.
Brandito plans to build on the same integration in a next phase, with Celigo sending stock levels to both storefronts so shoppers can see what is in stock before they order. Because each store connects only to Acumatica, the flows between Acumatica and ShipHero work the same for any store. Brandito plans to bring more of its storefronts onto the integration and reuse those flows for each new store with few changes.
Talk to an Integration Expert
Contact Us to Learn More
Ready to take your commerce solution to the next level? Complete the form below to discover how Snapshot's tailored solutions can optimize your operations and drive success for your business.
Why Companies Choose Snapshot:
At Snapshot, we don't just implement software, we assist companies in modernizing and scaling operations by simplifying operational complexity
NetSuite Consulting & Development
With over 12 years as a NetSuite Alliance Partner, we provide full-lifecycle consulting, SuiteApp development, and long-term optimization. Our focus is on leveraging NetSuite as the core engine of your business to drive scalability and predictive insights.
eCommerce Excellence
With over 25 years of commerce expertise, we understand that a storefront is only one piece of a much larger picture. Our approach takes into consideration your entire ecosystem, from the customer-facing experience to the critical business systems that power fulfillment, finance, and operations. We ensure your commerce platform isn't just a "bolt-on," but a high-performance tool built around your unique business architecture.
Data Integration Expertise
We specialize in high-performance connectivity using Celigo, Patchworks, and custom solutions. We focus on unifying disparate data silos to ensure your business operates with one cohesive data set.
Are your storefronts, warehouse, and ERP working from the same order?
Snapshot builds Celigo integrations that connect storefronts, warehouses, and your ERP, so orders run from checkout to a closed invoice. Let's lay the groundwork for your next phase of growth.
Talk to an Integration Expert
Contact Us Today
Ready to transform your business with modern technology solutions? Fill out the form below, and one of our experts will be in touch shortly to discuss how we can help drive success for your business.
Frequently Asked Questions
ShipHero can connect to Acumatica through a prebuilt connector listed on the Acumatica Marketplace that syncs ShipHero orders and fulfillment into Acumatica, or through an integration platform such as Celigo. For Brandito, Snapshot built Celigo flows in which orders reach ShipHero through the integration, each ShipHero shipment posts against the Acumatica order, the invoice closes, and tracking returns to the store. Goods receipts from ShipHero for both stores post into Acumatica as well.
An Acumatica multi-store ecommerce integration connects each storefront to the same Acumatica instance and can map each store’s orders, payments, and tax to the right branch and general ledger account. In Brandito’s setup, BigCommerce and BrightStores handle tax, payments, and gift certificates differently. For Brandito, Snapshot built Celigo flows that map each order to a storefront tax zone, post payments as Acumatica prepayments carrying the storefront transaction ID, and book gift certificates to each store’s liability account. Acumatica order numbers combine the customer and the store order number, which keeps numbers distinct across stores.
Celigo offers a BigCommerce – Acumatica quickstart integration template with prebuilt flows for customers, products, orders, billings, shipments, order cancellations, and customer refunds, and teams can also build custom flows on Celigo’s platform. For Brandito, Snapshot built Celigo flows that take BigCommerce and BrightStores orders into Acumatica, post ShipHero shipments and invoices, write tracking back to the store, and handle refunds, reships, and returns.
In Brandito’s integration, a return is created in ShipHero and goods are received against it, and Celigo then books a return order, a receipt, a credit memo, and a customer refund in Acumatica, with one receipt for each return. Refunds go to the original card, or to the customer’s account balance on BrightStores. A refund against a prepayment is applied to it and released, and a cancellation reverses the payment before the order is cancelled.
Snapshot builds Celigo integrations for Acumatica, as it did for Brandito. For other clients, Snapshot has delivered Celigo integrations with NetSuite and a Shopify integration with Acumatica built on Acumatica’s Shopify connector. Businesses planning an integration between storefronts, a warehouse, and an ERP can talk with a Snapshot integration expert about which approach fits their scope.
