Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

Record Track and Trace shipping information
(1 viewing) (1) Guest
Support forum for customers who have purchased this product. Archive only, no new post can be added.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1

TOPIC: Record Track and Trace shipping information

Record Track and Trace shipping information 9 years, 10 months ago #44395

I want to record the track and tracenumber of the shipment for each order. I do this using a SQL script called from within the shipping-labeling software. I think the best place to store this number is the Order Note, right?
In what table is this order note stored?
Or should I approach this totally different?
The topic has been locked.

Re: Record Track and Trace shipping information 9 years, 10 months ago #44398

Or is there a way to use the VM native order comments in VM invoice?
The topic has been locked.

Re: Record Track and Trace shipping information 9 years, 10 months ago #44433

  • pama
  • OFFLINE
  • Posts: 489
Hello. It is good approach to store it in Order Note. Order note is stored in database table (prefix)_vminvoice_mailsended in column called "params". It is object encoded as JSON so you must work with it. Object propety "order_note" is order note. :) But note that row in this table related to particular order not always exists (we create it only when needed), so you must insert it somehow if not exists yet.

Alternatively, we can write plugin for you that will store these track numbers and displays them on invoice using some new tag (different from {order_note}). It will be 1 hour of paid support, contact us if you want that.

Edit: VM native comments are {order_history} tag, but it will display whole history, not only tracking numbers.
ARTIO Support Team
Last Edit: 9 years, 10 months ago by pama.
The topic has been locked.
  • Page:
  • 1
User Login Empty