I tried to download Order CSV but since shipping method is not including by default template (no answer from my last post). Therefore, I'm trying to create a new temperate myself. However, by checking on "Use Custom Template" option", it only allow .xml for file extention. I didn't see extention for .csv or .txt from the Files of type. That's means it won't allow me to create templeate in .CSV format. Did I do something wrong?
Can someone help please!
Thanks
Speedy
Custom template for XML only?
-
- Commander (CMDR)
- Posts: 121
- Joined: Sat Sep 23, 2006 1:00 pm
Re: Custom template for XML only?
The export to CSV has a very limited set of fields because CSV can only support a flat (one row per order) structure. XML can support a relational structure (one order has many products, many shipments, many payments, etc).
What information/fields are you trying to download?
What information/fields are you trying to download?
-
- Commander (CMDR)
- Posts: 121
- Joined: Sat Sep 23, 2006 1:00 pm
Re: Custom template for XML only?
Hello David:
I'm trying to get daily sales infomation to feed into my shipping mangement programs available from Auctionsagesofware.com. We called "AS". It's a program that mainly designed for eBay sales handling in the begining, then it support Amazon recently. The good thing about the progrm is that it interactive with Endica.com for handling USPS mail. We printe lable in our office without doing stamps one by one at the Post office (they don't like it). It take care all my sales on eBay great for last 7 years. One of the feature from AS is data importing and exporting. It can import sales record from Amazon by reading CSV file that generate by Amazon. Without that features, we have to key in each sales made through Amazon. For eBay, the software taking care well through API. But I don't know really much about it.
What we need now: Since our website sales now is picking up and we have to deal tens order daily. It's very time consuming to key in each sales from the ABLE to the AS. I'm hoping that the exist Dataport tool will take care that matter for us. But without the shpping mthode specified, AS wont' be able to tell the shipping either and no way we can provide tracking info by uploading competing shipment CSV file tback to the ABLE.
FYI, the AS is desgined to read CSV file only. I'm wondering that if it can read Amazon files (single or multiple item), why couldn't it read CSV file from ABLE.
I really don't need any fency stuff but order handling only. As long as it let AS to read the sales record and be able to upload shipment info like shipping date, tracking, and change the stuts froom Pending to Completed. It's good enough for our operation!
Thanks
Speedy
I'm trying to get daily sales infomation to feed into my shipping mangement programs available from Auctionsagesofware.com. We called "AS". It's a program that mainly designed for eBay sales handling in the begining, then it support Amazon recently. The good thing about the progrm is that it interactive with Endica.com for handling USPS mail. We printe lable in our office without doing stamps one by one at the Post office (they don't like it). It take care all my sales on eBay great for last 7 years. One of the feature from AS is data importing and exporting. It can import sales record from Amazon by reading CSV file that generate by Amazon. Without that features, we have to key in each sales made through Amazon. For eBay, the software taking care well through API. But I don't know really much about it.
What we need now: Since our website sales now is picking up and we have to deal tens order daily. It's very time consuming to key in each sales from the ABLE to the AS. I'm hoping that the exist Dataport tool will take care that matter for us. But without the shpping mthode specified, AS wont' be able to tell the shipping either and no way we can provide tracking info by uploading competing shipment CSV file tback to the ABLE.
FYI, the AS is desgined to read CSV file only. I'm wondering that if it can read Amazon files (single or multiple item), why couldn't it read CSV file from ABLE.
I really don't need any fency stuff but order handling only. As long as it let AS to read the sales record and be able to upload shipment info like shipping date, tracking, and change the stuts froom Pending to Completed. It's good enough for our operation!
Thanks
Speedy
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: Custom template for XML only?
We have a report/export plugin that works for any sql query you can put into it. It shows the results in a grid then you can click a button and export to excel. It comes in very handy for merchants who want different files/different reports. You can add to .csv code or open the file in excel and change to .csv. We have done custom export to .csv routines, but created this to be re-usable and save the merchant from paying for numerous admin pages for reports.
http://www.web2market.com/Report-Export-Wizard-P96.aspx
http://www.web2market.com/Report-Export-Wizard-P96.aspx
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
-
- Commander (CMDR)
- Posts: 121
- Joined: Sat Sep 23, 2006 1:00 pm
Re: Custom template for XML only?
Thank you Judy. I'll do some study on that report see how much it can help on my case
Speedy
Speedy