AVeryNiceWeb

WP-Inventory

WP-Inventory

Postby admin » Fri Jan 13, 2017 2:24 am

Here we discuss this simple but fantastic plugin to keep inventory of assets, merchandise, any physical or virtual objects, you name it.
The AVNW Support Team
http://www.AVeryNiceWeb.com

If we have provided you with great information or service, there are a few ways you can show your appreciation:
  1. Become a AVNW Paid Subscriber.- We are constantly updating our data base with great tips and solutions to common problems, especially with Ultimate Member. If you found our site because of a WordPress issue, then your issue (if solved) will be published with the solution(s) for others to benefit from.
  2. Make a small donation.- We have buttons at the top and bottom that will allow you to do so via PayPal fast.
  3. Send us a testimonial.- Testimonials giving us praise for our good work is also valuable to us and encourages others to seek our support.
  4. Post a review (OP only).- If you came from a WordPress support board, posting a good review about our free service could also compel others to seek our advice & support.
  5. Like us on Facebook.- Recently our account had a problem on FB and we were forced to create a new one. We lost all our posts & likes. :(
If you do all 5, you'll get a surprise bonus from us. :)
Thank You!
User avatar
admin
Site Admin
 
Posts: 381
Joined: Mon Jan 13, 2014 3:18 am
Location: New York City

How to add another label and field item

Postby admin » Fri Jan 13, 2017 3:06 am

By default free wp-inventory plugin comes with a list of pre-formatted labels. For example, if you want to take inventory of items that have an expiration date (e.g. "Expiration") you are out of luck.

MySQL
So let's add a label parameter to the inventory list. First you need to add a column to the wp_wpinventory_item in your WordPress MySQL database. You should you phpMyAdmin on your hosting service cPanel.

Select the `wp_wpinventory_item' table => SQL tab. You can erase the first line in the big text box and enter this code:
Code: Select all
ALTER TABLE wp_wpinventory_item ADD inventory_expiration VARCHAR(60) AFTER inventory_model


Click on 'Go' button.

This will add a column named "inventory_expiration", however, once created, go to the table `wp_wpinventory_item' again and click on edit. You want to untick (deselect) the button for NULL, so that is not nulled (empty).

FileSystem

This code is hidden: 

To view this code please make a small donation or login to see it!

Now we have added a new label and field to the inventory list!
The AVNW Support Team
http://www.AVeryNiceWeb.com

If we have provided you with great information or service, there are a few ways you can show your appreciation:
  1. Become a AVNW Paid Subscriber.- We are constantly updating our data base with great tips and solutions to common problems, especially with Ultimate Member. If you found our site because of a WordPress issue, then your issue (if solved) will be published with the solution(s) for others to benefit from.
  2. Make a small donation.- We have buttons at the top and bottom that will allow you to do so via PayPal fast.
  3. Send us a testimonial.- Testimonials giving us praise for our good work is also valuable to us and encourages others to seek our support.
  4. Post a review (OP only).- If you came from a WordPress support board, posting a good review about our free service could also compel others to seek our advice & support.
  5. Like us on Facebook.- Recently our account had a problem on FB and we were forced to create a new one. We lost all our posts & likes. :(
If you do all 5, you'll get a surprise bonus from us. :)
Thank You!
User avatar
admin
Site Admin
 
Posts: 381
Joined: Mon Jan 13, 2014 3:18 am
Location: New York City


Return to Plugins

Who is online

Users browsing this forum: No registered users and 1 guest

cron