X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Dev Questions (X-Cart 5) (https://forum.x-cart.com/forumdisplay.php?f=56)
-   -   Shipping labels (https://forum.x-cart.com/showthread.php?t=68843)

mworsnop 03-12-2014 02:21 PM

Shipping labels
 
I need to be able to generate label for shipping. It appears right now I have to click on each on and see the details and cut and paste. Is there some other way?

If there isnt anything available can you please tell me the names of the tables so I can generate a report for this information?

tony_sologubov 03-19-2014 05:24 AM

Re: Shipping labels
 
Hi Mark!

Unfortunately, shipping label generators are not implemented yet, but you can pull info about shipping by following MySQL queries:
Code:

[select * from xc_order_surcharges where type="shipping";


It will pull shipping cost info.

If you need to pull the shipping method name for the order, you can do it like this
Code:

select xc_shipping_method_translations.name from xc_shipping_method_translations, xc_orders where xc_orders.orderNumber = %YOUR ORDER ID% and xc_orders.shipping_id = xc_shipping_method_translations.id;

mworsnop 03-19-2014 08:24 AM

Re: Shipping labels
 
Thank you Tony. I worked up a report using Crystal Reports. I will have to get that installed on the persons desktop so they can run it themselves. Its a good work around for now, After I get them online and they are happy I will go back and try to learn the modules. I can write it in PHP, but thats not really something to generate reports in directly. Havent thought too much about the alternatives yet as the Crystal Reports works. thanks for the help!

tony_sologubov 03-20-2014 04:10 AM

Re: Shipping labels
 
Mark, can you please tell me a little more about Crystal Reports? What kind of reports they are doing and why have you chosen them? Probably, we should try to contact them and arrange some kind of integration with X-Cart 5.

carpeperdiem 03-20-2014 05:12 AM

Re: Shipping labels
 
Quote:

Originally Posted by mworsnop
I need to be able to generate label for shipping. It appears right now I have to click on each on and see the details and cut and paste. Is there some other way?


If you are in US, look at ShipStation

Yes, it's a SaaS - but it integrates with X-Cart perfectly. Shipstation also sends shipping notifications with tracking and it also integrates with other shopping platforms, such as amazon, rakuten, ebay, etc..

If you ship more than a few packages a day, it will save you $.
You get a free endicia account included, so factor that in.

I do not know if they have the integration for XC5 yet. Works perfectly with 4.5.4

mworsnop 03-20-2014 07:12 AM

Re: Shipping labels
 
Tony - Crystal Reports is a developer application enabling developers to create reports. Its a clean slate when you get it, no reports. Using it you can drag and drop fields and create reports.


All times are GMT -8. The time now is 06:43 AM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.