I am looking for a report that will include the following fields from My Volusion ecommerce site.
Customer first name
Customer last name
Customer Email Address
Product Vendor Name
Product Vendor Number
Product Warehouse Name
order details (Multiple Vendors)
Transaction ID( PayPal)
Transaction Details (PayPal)
Individual shipping Charges (Drop ship from different warehouses
Order Price Total
To give a more details of what I am looking for, I need a report that I will run every quarter to give me the details of all the transactions including specific vendor and or warehouse and the individual shipping cost per warehouse per items sold, I also would like the payment information from Paypal who is our exclusive payment provider, I need this information to be accurate and able to run this report whenever we need to but a minimum of once every 3 months.
The store is configured to drop ship all items so the vendor receives an email when an item has been purchased and where to ship that item, the details the vendor gets does not have the shipping cost provided and when I spoke with Volusion they said it was how the store was built, I am hoping that there is another way to extract this information for this report.
12 freelancers are bidding on average $162 for this job
Hello, I'm MySQL, MSSQL server, databases expert with 11 year experience. Ready to start ASAP. Can deliver the report in a day, in your desired format (csv, pdf, etc). Please check PMB.