{"id":4393,"date":"2020-04-13T09:22:37","date_gmt":"2020-04-13T09:22:37","guid":{"rendered":"https:\/\/litextension.com\/faq\/docs\/shopping-cart-questions\/volusion\/how-to-export-database-from-volusion-to-csv-files-when-you-got-server-down-error\/"},"modified":"2021-05-10T04:27:49","modified_gmt":"2021-05-10T04:27:49","slug":"export-database-from-volusion-to-csv-files","status":"publish","type":"docs","link":"https:\/\/litextension.com\/faq\/docs\/shopping-cart-questions\/volusion\/export-database-from-volusion-to-csv-files\/","title":{"rendered":"How to export database from Volusion to CSV Files when you got server down error?"},"content":{"rendered":"

When you have been exporting files from Volusion, if Volusion has a lot of data, it will show\u00a0error 502 Bad Gateway.<\/p>\n

\"502<\/p>\n

You don’t need to select the option Check All on Columns. Could you please check list fields which are used on your migration:<\/p>\n

Products<\/strong><\/p>\n

Could you please check list fields: ID, productcode, productname, hideproduct, stockstatus, lastmodified, ischildofproductcode, productnameshort, productweight, recurringprice, productprice, listprice, saleprice, metatag_title, metatag_description, productmanufacturer, photo_subtext, photo_alttext, setupcost, productdescriptionshort, productdescription, productfeatures, metatag_keywords, categoryids, optionids, photourl, photourl_large, donotallowbackorders, customfield1, customfield2, customfield3, customfield4, customfield5, photos_cloned_from<\/p>\n

\"export<\/p>\n

\"export<\/p>\n

Customers<\/strong><\/p>\n

Please check list fields: customerID, accesskey, firstname, lastname, companyname, billingaddress1, billingaddress2, city, state, postalcode, country, phonenumber, faxnumber, emailaddress, emailsubscriber, lastmodified, customer_notes, createddate<\/p>\n

\"export<\/p>\n

Orders<\/strong><\/p>\n

Please check list fields: orderID, customerid, billingcompanyname, billingfirstname, billinglastname, billingaddress1, billingaddress2, billingcity, billingstate, billingpostalcode, billingcountry, billingphonenumber, billingfaxnumber, shipcompanyname, shipfirstname, shiplastname, shipaddress1, shipaddress2, shipcity, shipstate, shippostalcode, shipcountry, shipphonenumber, shipfaxnumber, shippingmethodid, totalshippingcost, salestaxrate, paymentamount, paymentmethodid, cardholdersname, creditcardexpdate, creditcardauthorizationnumber, creditcardtransactionid, bankname, orderdate, orderstatus, total_payment_received, total_payment_authorized, salestax1, salestax2, salestax3, ordernotes, order_comments, orderdateutc<\/p>\n

\"export<\/p>\n

Orders detail<\/strong><\/p>\n

Please check list fields:\u00a0 orderdetailID, orderid, productcode, productname, quantity, productprice, totalprice, optionids, options, discounttype, discountvalue<\/p>\n

\"export<\/p>\n

In case you have any other questions, please reach out to us via:<\/p>\n