For E-commerce Success
Integrating B2B pricing from SAP ERP system into existing Shopify store.
Companies put in considerable effort within ERP to define their price, shipping, and tax determination.
Shopify is suited for B2C businesses where B2C prices can be set up.
Being a SaaS based application Shopify has limitations on the changes that can be made eventually not allowing B2B store owners to integrate their ERP pricing on checkout.
Retail buyers log into Shopify and navigate through the website.
At this point of time the Shopify prices are shown with a disclaimer that prices can change at checkout.
The end customer adds items to the cart at this point of time.
When the user checks out API price simulation for is called.
The API will revise the item prices in the cart.
The API will revise the tax rate Shopify uses for calculation.
The API may also add new goods to the cart or remove the quantities from the cart.
The API will provide shipping charges to be used for checkout.
The client requested the creation of custom fields for “Sold to Number” and “Ship to Number,” a disclaimer about potential price changes at checkout, and changes to the checkout process to call a custom API with specific inputs and outputs.
Shopify will use this information and do the following:
Stores list prices for each SKU in the cart
Updates the tax rate based on the API response
Won ClearlyRated’s Best of Staffing Talent Award
Calls the API to retrieve ERP prices
Modifies the cart according to the API response
Sets the prices back to list prices
Shopify will use this information and do the following:
If a customer adds an item listed at $23.00, the checkout process will update the price to $20.00 based on the SAP price, with shipping at $5.00 and a 10% tax rate, while the list price remains unchanged.
Our team leveraged the Node boilerplate provided by Shopify to gain in-depth understanding of its structure and database framework.
Maintaining application security through proper authentication was a significant challenge. We addressed this by implementing Shopify Auth, strictly following Shopify’s developer guidelines for secure authentication.
Managing session tokens for secure API calls to Shopify Admin APIs was another major hurdle.
Used when the application needs resources without immediate user presence.
Used when a user is actively using the application.
Initially deployed on both Heroku and Fly.io for environment understanding. Eventually, opted for exclusive hosting on Heroku for the final deployment.
Default SQLite database in Shopify Node app boilerplate lacks persistence. Addressed by migrating to PostgreSQL for robust data management.
Utilized webhooks and data manipulation for B2B pricing at checkout.
Triggered by Shopify webhook “CHECKOUT CREATE” to initiate checkout attempts.
Data captured included customer and cart information for processing.
Products were transformed to meet SAP API requirements.