• Resolved shieldmanagement

    (@shieldmanagement)


    We’re looking to start using and building reports but we can’t see where in the tables is the data being saved. Can you let us know where we can find the location information for the item?

    We’re looking to build reports of items by location as well as inventory reports so we can manage our inventory

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Stock Management Labs

    (@stockmanagementlabs)

    Hi shieldmanagement,

    Thank you very much for your post.

    I am very sorry, but can’t help you with this right now. The location info is just for reference right now.

    We will be releasing fully featured locations add-on including reporting later this year.

    Did you want to code the feature yourself?

    Hope to hear from you soon.

    Best Regards,

    Pavel

    Thread Starter shieldmanagement

    (@shieldmanagement)

    We’re just looking for where the data is saved, like which table and column in the database. Usually these are in the postmeta.meta_value area which works but is a pain.

    I’m assuming there’s a link to the location we save in the post or postmeta for each product which references the postid for the category of the location name. We’re just looking for what that info’s called.

    We use various reporting tools to pull information directly from the database so we can build reports. We need to be able to add the inventory location on inventory reports so we can manually verify the item stock and location.

    Do you not know where your data is stored?

    Plugin Author Stock Management Labs

    (@stockmanagementlabs)

    Hi shieldmanagement,

    Thank you very much for the reply.

    I have forwarded the enquiry to our senior developer.

    We will get you an answer tomorrow whe guys get back to work.

    Hopefully, that’s ok.

    Pavel

    Plugin Author Salva Machi

    (@salvamb)

    Hi shieldmanagement,

    The locations are just standard WP taxonomies of the post type product, so it works like any other WP taxonomy.

    The name of this taxonomy is atum_location

    If you want more info about how taxonomies are handled in WP, I suggest you to read these Codex articles:

    https://codex.wordpress.org/Taxonomies

    https://codex.wordpress.org/Database_Description

    Best Regards,
    Salva.

    Thread Starter shieldmanagement

    (@shieldmanagement)

    Thank you!!! we found the term table and were able to link the postID to the termID and select only atum_location. This allows us to build reports for inventory as well as pick lists. Cant wait until you guys release more features.

    Plugin Author Stock Management Labs

    (@stockmanagementlabs)

    Excellent, I am glad Salva was able to help you guys.

    Be good and keep your business growing.

    Pavel

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘where is data saved’ is closed to new replies.