I am trying to import few hundred customer through CSV file. System is able to import all of them without any error but is ignoring Total Spent and Total Orders fields. I tried exporting the imported customers and filled these two columns with actual values but no success.
CSV file can be accessed here
Hi Graydon, these fields are calculated based on orders in the system and can't be overridden when importing existing customers. You can import your orders using our Order API and associate them with specific customers to show accurate total spent and total orders for a given customer.
You can import your orders using our Order API
Hi Jonathan, that sounds exactly the thing we need. We're trying to use Shopify to keep track of orders both online and in store - it would be ideal to do a daily import of store orders into Shopify. Is there any documentation or (preferably) an App that does this for us?
You can check out the Order API in our docs. An app would need to be aware of what format your in-store orders are in. What are you using to track those orders? Also, have you looked into Shopify POS? You'd be able to easily track sales between online and in-store, using the same customer and product info.