Custom application design and HubSpot integration
About the client
Founded in 2008 by artist Bari Ziperstein, BZIPPY is a ceramic furniture and housewares company producing open edition wares. Inspired by architecture and industrial design, BZIPPY builds on a taxonomy of slab-based and extruded forms to deliver high-quality, rigorously handbuilt, functional ceramic objects. BZIPPY furniture and housewares are included in multiple high-end showrooms, lifestyle stores, and its clients include many prominent interior designers.
BZIPPY needed an easy way to manage their product catalog, centralized in one application. The solution needed to allow for management of inventory levels for parent and child products, as well as limited edition, specialty products. Pricing management was also needed, calculating the price of a specific SKU based on the type of Glaze being applied to the base product.
The full product catalog needed to be managed as well including Name, Description, Images, and category assignment.
Lastly, the application had to support integrations with Quickbooks, Salesforce, and WooCommerce.
MPS created a base in Airtable, with several tables and interfaces. The master table includes all main product data and allows easy management of descriptions, images, and other product-specific data.
Currently supporting a single warehouse, the Inventory table manages qty available, on sales order, and an inventory allocation for the WooCommerce store.
A table for management of pricing was added to determine final retail pricing easily for all products, starting with a base item cost, then percentage markup based on the glaze applied to the product.
Integration with WooCommerce
MPS integrated the Airtable base with WooCommerce. Using a modified date/time field, MPS is change tracking the Airtable data and syncing updates to WooCommerce as users add/edit data in Airtable. As customers place orders on WooCommerce, the inventory allocations are updated in Airtable.