X-Cart forums

[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 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]

Hi Mark!

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

[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

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]

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]

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]

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]

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.