When you’re running a business, there’s a ton to do and every minute matters. ⏰ If errors occur, they can cost you time and money … and both can lead to a lot of frustration. 😡
When attempting to run an API export for the Orders or Customers tables, you may encounter the following error:
System.Data.SqlClient.SqlException: Invalid column name
A common cause for this error is when Custom Fields have been added to the Orders or Customers databases. The quick fix: simply delete the old Orders and Customers API files from your store's FTP.
After deleting the old files, new Orders and Customers API files can be generated with the additional Custom Fields, and you’ll be back to smooth sailing! ⛵
To Delete The Old API Files ...
- Log in to your store's FTP account (For instructions on accessing your store’s FTP, check out "How to Set Up Your Volusion FTP (SFTP) Account" and "How to Use Your Volusion FTP (SFTP) Account"
- Go to the /vspfiles/schema/generic folder
- Find the Orders.xsd and/or Customers.xsd files and delete them (You only have to delete the file(s) associated with the API table for which you are getting an error)
- Re-run the API export for the table you need and the file will regenerate itself with the new Custom Fields
Your API should now be synced with your store Orders and/or Customers database tables, including the additional Custom Fields.
Don’t get tripped up by a common ecommerce error. Follow our easy fix and, don’t forget, you can always reach out to our support team for more help.