Pre-Sales Question

  • Resolved uebes

    (@uebes)


    5 years, 5 months ago

    I need the new order number (sequentiell and with prefix) for some sql reports.

    Do you save the new order number to the DB (e.g. postmeta) so that it is possible to show the new number in a sql query?

    Best regards
    Siegfried

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support kenil802

    (@kenil802)

    5 years, 5 months ago

    Hi @uebes,

    Could you please tell us whether you want the new order to be saved in DB along with the prefix and suffix?

    Do let us know so that we can assist you in a better way.

    Regards,
    Kenil Shah

    Thread Starter uebes

    (@uebes)

    5 years, 5 months ago

    I am using some sql query’s for different reports (no woocommerce reports) in my special woocommerce solution for our FoodCoop nonprofit organization.

    I checked the db postmeta and found the field (_alg…..) for the new custom order number. But I can‘t find the field with the suffix or prefix.

    I need both together with the new order number. It makes no sense to use new customized order numbers and they are not shown in our reports.

    Regards
    Siegfried

    Plugin Support kenil802

    (@kenil802)

    5 years, 5 months ago

    Hi @uebes,

    Apologies for the delay in response.

    We are not saving the custom order numbers with prefixes or suffixes in the database.

    Do let us know if you have any further queries.

    Regards,
    Kenil Shah

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Pre-Sales Question’ is closed to new replies.