Extensions - (VQMod) What Product Is This?

(VQMod) What Product Is This?

Extension Name	(VQMod) What Product Is This?	Rating
Extension Name	(VQMod) What Product Is This?
License	Commercial	Votes	0
Price	$10.00	Views	3414
Developer	KatGirl	Request Support
Date Added	16 May 2012	Report extension
Date Modified	25 July 2012

Do you sell both Digital and Tangible products? Do you know what products are digital and/or tangible when you view your admin product list page? Wouldn't it be nice if you could see exactly what type of product you're selling at a glance? Well, now you can!

FEATURES
=========
What Product Is This is VQMod file so no core files are touched. Better still, this super handy mod allows store owner and staff to see at a glance exactly what type of product you're selling.

If you sell both digital and tangible (requires shipping) goods, its nice to see where those products are in your product list page as soon as you navigate to the page so editing or updating your products because easier.

A must have for any store owner who sells both digital and tangible goods.

Front End Features
=================
I've updated the mod to allow the store owner to display the matching icons on the theme's single product page. This is also handy for your business as you can define what type of product you're selling straight to your customer!

Version History:
============
30/05/201: Updated to latest release: V1531
Compatible Versions: V1513, V1521, V1530, V1531

26/07/2012: Updated mod to allow store owner to display icons on theme's single product page. This is a separate vqmod file packaged together.

I hope you like it. Please leave a comment and rate my little mod if you like it.

KatGirl

Requirements
==========
VQMod must be installed. You can get the latest version here: http://code.google.com/p/vqmod/wiki/Install_OpenCart
FTP Software
Access to your database

Other VQMod Extensions
===================
http://www.opencart.com/index.php?route=extension/extension&filter_username=KatGirl

Downloads Documentation Comments (19)

You must buy a license to download this extension click here.

Download Name	Compatibility	Action
What_Product_Is_This.zip	v1.5.1.3, v1.5.2.1, v1.5.3, v1.5.3.1	[ Download ]

The latest version of this VQMod can be downloaded at any time from: http://www.opencart.com/index.php?route=extension/extension&filter_username=KatGirl

Version History:
============
30/05/201: Updated to latest release: V1531
Compatible Versions: V1513, V1521, V1530, V1531

26/07/2012: Updated mod to also include an option for the store owner to display the icons on theme's single product page.

The latest version of this VQMod can be downloaded at any time from: http://www.opencart.com/index.php?route=extension/extension&filter_username=KatGirl

BASIC REQUIREMENTS:
============================
1. VQMOD Installation (mandatory)
2. VQMOD Manager Extension (optional but considered really, really useful)
3. FTP Software (required)

--------------------

FILES MODIFIED/OVERWRITTEN? NO
DATABASE ALTERED? YES (read instructions below)

-------------------

BACK END ONLY:
===============
NEW FILES TO UPLOAD: (2)
root >> upgrade.php (alters your database!)
catalog >> view >> theme >>
vqmod >> xml >> what_product_is_this_admin_side.xml

-------------------

FRONT END
=========
FILES TO UPLOAD: (1)
vqmod >> xml >> show_what_product_is_this_icons_product_page.xml
IMPORTANT! PLEASE READ NOTES BELOW.
-------------------

FILES TO CHANGE: NONE

---------------

IMPORTANT: UPGRADE DATABASE FIRST!
===================================
Before uploading the VQMod xml file to your store you must upgrade your database.

This VQMod requires a new table insertion "type" to be added to your store's existing database. The upgrade.php file is a "One click" upgrade and upon success, the script will self-delete from your server so you do not have to manually delete it.

The script was built this way for security reasons.

STEP 1 - GAIN ROOT ACCESS TO YOUR STORE
========================================
Using FTP software, go to the root of your OpenCart installation. You should see files and folders structure like below for a default non-modified installation:

admin (folder)
catalog (folder)
download (folder)
image (folder)
system (folder)
vqmod (folder)
.htaccess (file)
config.php (file)
index.php (file)
php.ini (file)

This is the root of your OpenCart install. Using FTP Software, upload the upgrade.php file from your desktop and drop into the root access of your OpenCart install. No files will be overwritten.

STEP 2 - RUN DATABASE UPGRADE SCRIPT
====================================
Open a new browser window and type your OpenCart STORE address as you would if you needed to gain ADMIN access but add the upgrade.php script to the URL at the end, like below:

example: http://www.mywebsite/store/upgrade.php OR http://www.mywebsite.com/upgrade.php

This is an automatic upgrade! When you hit 'enter' on your keyboard, the script will automatically run. Upon successful database upgrade, you will see a message confirming this.

There is no need to delete this file! It will automatically self-delete for security reasons.

STEP 3 - ADD VQMOD FILE - admin side only
============================================
1) Upload what_product_is_this_admin_side.xml file via VQMod manager (if you don't have VQMod manager, notes below)

2) Go to: Catalog >> Products >> Any product you like. Click Edit

3) In the General Tab section, you will see a new field called: Product Type: and a new dropdown box. Select what the product is: Digital or Tangible. Click Save.

4) Go to the Product List page, and you will now see icons that show you at a glance exactly what type of product you are selling: either digital (downloadable) or tangible (requires shipping).

5) You're done!

STEP 3 - MANUAL VQMOD INSTALLATION - admin side only
=============================================
1) Upload what_product_is_this_admin_side.xml file using FTP Software to root >> vqmod >> xml folder.

2) Go to: Catalog >> Products >> Any product you like. Click Edit

3) In the General Tab section, you will see a new field called: Product Type: and a new dropdown box. Select what the product is: Digital or Tangible. Click Save.

4) Go to the Product List page, and you will now see icons that show you at a glance exactly what type of product you are selling: either digital (downloadable) or tangible (requires shipping).

5) You're done!

STEP 4: SHOW ICONS ON THEME'S PRODUCT PAGE!
===========================================
I have included a bonus xml file as an optional extra for those who want to display the matching icons (digital/shipping) on the theme product page.

Please upload the following file AFTER installing what_product_is_this_admin_side.xml first, using vqmod method as outlined in STEP 3 - VQMOD Installation or Manual VQMod Installation:

show_what_product_is_this_icons_product_page.xml

MANUAL DATABASE INSERTION
============================
The database upgrade.php script adds a new field inside your database. If you prefer to do this manually, you can.

1) Open CPANEL and navigate to: DATABASES >> phpMyAdmin. This will open a new window for you.

2) Select the correct database for your store. If you installed OpenCart via Installatron, go to Installatron Applications, and find your install. Click "View Details". Your database information is there.

3) Once you are sure you are viewing the correct database for your OpenCart install, click "product" field from the left hand sidebar. On the right, all table enteries relating to the Product field will display.

4) Go to ‘structure’ and add one more field named ‘type’ and place it after ‘upc’ field.

5) Set the field type =‘integer’ and length=2.

6) You're done.

7) Now you can upload the vqmod file.