Background:
I have a shopping cart and using fedex as my shipping. Unfortunately, the shopping cart does not connect with fedex directly to print out the shipping labels, get tracking number and everything else, it just gives the rate of the shipment. I contacted fedex and they gave me a software to batch upload all orders at once, or individually. Problem, my cart does not export shipping info in csv, so I either have to go into the database every day to export and create a custom query in the format of fedexs csv uploader, or type each order out individually. I would rather not do either of those.
Prefer:
I would like to set up a web page in my general admin area where I could query the database from online and it spits out a straight csv file or a zipped csv file with the info requested. It took quite a few hours on my end, being ignorant to this whole programming thing, to make the initial query statement that needs to run..
SELECT orders_id, customers_company, customers_name, delivery_street_address, delivery_suburb, delivery_city, delivery_state, delivery_country, delivery_postcode, customers_telephone FROM `gp_orders` WHERE orders_id>147
What I need to be able to happen is the query of "orders_id>147" needs to be a text area that I type the number into. That is the first order of the day and I would type it in, that way I only get the orders of this day to spit out when I press the link or submit button.
And I know there are other carts out there that may do this, but I prefer this cart and it has a whole lot of other features.
Can someone help me put together this php page?
Thanks.
