Is anyone having trouble with the Order History Importer? I’m trying to import a small test file and it’s just sitting there.
Our internet connection can be a bit wobbly sometimes, but this is the second day I’ve had the same result. I have the necessary fields filled in and am using the correct file type. I’ve managed to import orders before so not sure what’s going wrong this time!
I have had this happen to me, you go to upload and it looks like nothing is happening. This has generally been because one of the columns is in the wrong format, generally the date, which in Aust needs to be dd/mm/yyy
@tom1 Is correct. Usually when it stalls without an CF error, it means the formatting of the data is incorrect. The order history import doesn’t require many fields, but the formatting needs to be in unison all the way down your columns. Such as phone numbers can be (707) 555 - 5555 or 805 - 555-5555. Or the pickup location code, not the name. Double check the requirements here: https://documentation.vin65.com/Settings/Import-Export/Order-History-Importer
You may be able to see which row the import stops on to get a general idea where to start looking. You can import up to 50k rows but would want to keep it roughly 10k to mitigate risk. Give it another shot and lets us know how it goes.
Thanks @Tom1 and @cmacinnes - it was the date formatting. If you scroll to the bottom of the documentation, there is this sentence:
Australian clients would need to adjust the Date format for any Date related columns to YYYY-MM-DD
So that’s the format I was using. Have since changed it to DD/MM/YYYY and imported without trouble. Thanks for your help 