OpenCart Community

Does anyone know where or how the tracking field in the order table is populated or displayed?

I'm migrating from another cart and would like this information to be viewed on old orders, and also to be of use moving forward with new orders when our site is up and running.
Ta

You'd need an extension to import your old orders. See this free extension: https://www.opencart.com/index.php?rout ... sion_id=17 .

I'm using a paid service to import from all the relevant database info from Magento, which seems to do a good job, but looking at that extension you mentioned it only seems to import products/categories.

Anyway, researching a little more and thinking about it, shows the field not to be actually that relevant for actual shipment tracking as a (small) percentage of orders aren't always fulfilled at the one time, so may have multiple tracking numbers for dispatches over a number of different days. I see there are a number of extensions that could be utilised to achieve this.

I also came across a table in the database called order_shipment, this looks ideal but again does anyone know where & how it gets populated?

ilclark wrote: ↑

Fri May 07, 2021 9:56 am

I'm using a paid service

You could ask them?

ilclark wrote: ↑

Fri May 07, 2021 9:56 am

I'm using a paid service to import from all the relevant database info from Magento, which seems to do a good job, but looking at that extension you mentioned it only seems to import products/categories.

Anyway, researching a little more and thinking about it, shows the field not to be actually that relevant for actual shipment tracking as a (small) percentage of orders aren't always fulfilled at the one time, so may have multiple tracking numbers for dispatches over a number of different days. I see there are a number of extensions that could be utilised to achieve this.

I also came across a table in the database called order_shipment, this looks ideal but again does anyone know where & how it gets populated?

This database table is on the road of deprecation for future OC releases on the Github Opencart repository. You'd have to try with other extensions on the Marketplace if your service cannot achieve this. Otherwise, you could always create a new service request in the Commercial Support section of the forum to get this done as a custom job.

Hi Paul, I know how to populate the tracking field as part of the Magento migration so I don't lose that information after we finish migration, so that part is fine. It's the order_shipment table moving forward I wanted to explore, it seems to be the correct solution for that part of the software. As part of typing this reply, and based on what Starlight has said I did a quick scan across files for use of the table, none found, is that correct? If so looks like it's already been deprecated.

Strange.

straightlight wrote: ↑

Fri May 07, 2021 7:43 pm

ilclark wrote: ↑

Fri May 07, 2021 9:56 am

I'm using a paid service to import from all the relevant database info from Magento, which seems to do a good job, but looking at that extension you mentioned it only seems to import products/categories.

Anyway, researching a little more and thinking about it, shows the field not to be actually that relevant for actual shipment tracking as a (small) percentage of orders aren't always fulfilled at the one time, so may have multiple tracking numbers for dispatches over a number of different days. I see there are a number of extensions that could be utilised to achieve this.

I also came across a table in the database called order_shipment, this looks ideal but again does anyone know where & how it gets populated?

This database table is on the road of deprecation for future OC releases on the Github Opencart repository. You'd have to try with other extensions on the Marketplace if your service cannot achieve this. Otherwise, you could always create a new service request in the Commercial Support section of the forum to get this done as a custom job.

Why would this be done? Is there something new being added to handle the shipment / tracking of orders in a future release?

ilclark wrote: ↑

Mon May 10, 2021 9:21 am

straightlight wrote: ↑

Fri May 07, 2021 7:43 pm

ilclark wrote: ↑

Fri May 07, 2021 9:56 am

I'm using a paid service to import from all the relevant database info from Magento, which seems to do a good job, but looking at that extension you mentioned it only seems to import products/categories.

Anyway, researching a little more and thinking about it, shows the field not to be actually that relevant for actual shipment tracking as a (small) percentage of orders aren't always fulfilled at the one time, so may have multiple tracking numbers for dispatches over a number of different days. I see there are a number of extensions that could be utilised to achieve this.

I also came across a table in the database called order_shipment, this looks ideal but again does anyone know where & how it gets populated?

This database table is on the road of deprecation for future OC releases on the Github Opencart repository. You'd have to try with other extensions on the Marketplace if your service cannot achieve this. Otherwise, you could always create a new service request in the Commercial Support section of the forum to get this done as a custom job.

Why would this be done? Is there something new being added to handle the shipment / tracking of orders in a future release?

Yes, there is something new; these are called: extensions . They then can be downloaded / purchased from the Marketplace or from 3rd party websites. However, take note that the forum does not support paid licensing support with the exception of extension developers creating and announcing their official support topic on the forum to troubleshoot their extensions with their users.

As an alternative, the master branch, later on, could contain future ideas where worldwide developers can rely on with their stores. However, no support are being provided for these types of integrations with the exception of custom jobs which service requests can be created in the Commercial Support section of the forum for paid assistance.