Currency Convertion on Shopify while importing products in Dollars to(India) INR

Store Design
, ,

Topic summary

A Shopify store owner in India (base currency: INR) is importing products from multiple dropship suppliers. While most suppliers provide prices in INR, one US/UK supplier lists products in USD, creating a currency conversion challenge at import.

Proposed Solutions:

  • Currency conversion/import apps: Tools like Matrixify (Excelify), Syncee, or DataFeedWatch can apply exchange rate transformations during import, with supplier-specific conversion rules
  • Custom middleware script: Build automation using PHP/Node.js/Python that fetches USD prices, calls a currency API (OpenExchangeRates, Fixer), converts to INR with a markup buffer, then pushes to Shopify via Admin API
  • Manual CSV workflow: Download supplier CSV, apply conversion formula in Excel/Google Sheets (e.g., multiply by current exchange rate), then re-import

Key Considerations:

  • Shopify doesn’t auto-convert supplier costs; all prices must be in the store’s base currency (INR) before import
  • Add a 3-5% buffer to exchange rates to account for daily fluctuations
  • Automation is recommended if supplier feeds update frequently

The discussion remains open with no confirmation of which approach the store owner will implement.

Summarized with AI on October 24. AI used: claude-sonnet-4-5-20250929.
1

HI Shopify Architects, I have a Shopify site with a customized theme, with base currency as INR (Indian Currency).Currently I have multiple droship suppliers on my site who are providing the products in INR , however one of the suppliers is from US/UK who provide products in $$.
My Question is , while importing the products from his dashbaord, the Dollars need to be converted to INR while reaching my storefront , how can I do that ? Is there an APP, or a customization in Shopify that I can use? (My site is India Based only)

2

Hi @Basu ,
Here are your best options:

1. Use a Currency Conversion / Import App

There are apps on the Shopify App Store that handle supplier feed imports + currency conversion:

  • Matrixify (Excelify) – lets you import product CSVs and apply transformations (like multiplying USD prices by exchange rate before saving).
  • Multicurrency Import Apps – some feed management apps (e.g., Syncee, DataFeedWatch, or Spreadr for dropshipping) allow you to set a conversion rule per supplier.
  • Look for features like “supplier-specific markup / conversion”. You’d set price = supplier_price_in_usd × conversion_rate.

2. Custom Script During Import

If your supplier provides a CSV, XML, or API:

  • You can write a middleware script (small PHP, Node.js, or Python script) that:
    1. Fetches products in USD.
    2. Calls a currency exchange API (e.g., OpenExchangeRates, Fixer).
    3. Converts USD → INR with a buffer percentage (since rates fluctuate).
    4. Pushes the adjusted INR prices into Shopify via the Admin API.

This way, Shopify only ever sees INR values.

3. Manual CSV + Formula Trick

If you’re fine with semi-manual work:

  • Download supplier CSV in USD.
  • Open in Excel/Google Sheets.
  • Add a formula to convert USD → INR (e.g., =A2*83 if 1 USD = ₹83).
  • Save and import back into Shopify.

This works if updates are infrequent.

4. Important Notes

  • Shopify does not automatically convert supplier costs — the base store currency (INR) must be respected in the import.
  • You’ll want to add a buffer margin (say +3–5%) on the exchange rate, since INR/USD fluctuates daily.
  • If the supplier’s feed updates daily, automation (Option 1 or 2) is your best bet.