AVeryNiceWeb

WP-Inventory

WP-Inventory

Postby admin » Thu Jan 12, 2017 10:24 pm

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

We also have great domain names for your next website. Go through the list and make an offer now!

Shopping for a new website? See our design deals.

How much is your website worth? Get a free estimate.

And, if our post has provided you with great information, there are a few ways you can show your appreciation:
  1. Like us on Facebook
  2. Post a review.- Posting a good review about this site could help us provide improved support.

Thank You!
User avatar
admin
Site Admin
 
Posts: 480
Joined: Sun Jan 12, 2014 11:18 pm
Location: New York City

How to add another label and field item

Postby admin » Thu Jan 12, 2017 11:06 pm

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

We also have great domain names for your next website. Go through the list and make an offer now!

Shopping for a new website? See our design deals.

How much is your website worth? Get a free estimate.

And, if our post has provided you with great information, there are a few ways you can show your appreciation:
  1. Like us on Facebook
  2. Post a review.- Posting a good review about this site could help us provide improved support.

Thank You!
User avatar
admin
Site Admin
 
Posts: 480
Joined: Sun Jan 12, 2014 11:18 pm
Location: New York City


Return to Plugins

Who is online

Users browsing this forum: No registered users and 0 guests

cron