Here is the order insertion method via SQL query ...
How to connect Volusion DB without using admin panel
I want that how to write insertion SQL query for product. Is it same like the order or different??
Also i am totally confuse that which type of data format is volusion API support?? i am passing XML data.
XSD file is why needed for insertion like in this link ..
https://support.volusion.com/hc/en-us/articles/209638947
There is a lot of Export methods but no perfect and proper Import method via Volusion API.
Anyone knows please help me i have post 3 questions about this issue no can give perfect and correct answer that do good.
Do you have to use the Volusion API for this? In other words, does it have to be automated?
In most cases I find myself using the "standard import" and "standard export" feature within the store admin.
Even if I have to prepare the CSV file dynamically, and upload it manually, I prefer this method.
For queries where I have to update or delete many records based on certain criteria, I use the "bulk updates" feature in Volusion. You will see it in the admin under certain sections. If you click "Switch to Advanced View" you can run a valid SQL query here ... for example:
DELETE FROM Customers WHERE LastName = 'temp'