Opencart to do and wish list - Revision history

Ted at 21:50, 2 November 2021

2021-11-02T21:50:09Z

Ted: /* Useful Queries to OC Database */

2021-11-02T21:49:45Z

Useful Queries to OC Database

Ted: /* Opencart Issues */

2021-10-19T06:15:21Z

Opencart Issues

Ted: /* Opencart Issues */

2021-10-19T06:15:08Z

Opencart Issues

Ted: /* Opencart Issues */

2019-11-17T07:18:31Z

Opencart Issues

Ted at 19:18, 16 November 2019

2019-11-16T19:18:05Z

Ted at 15:16, 7 September 2017

2017-09-07T15:16:00Z

Ted: /* OpenCart Feature And Capabilities Wish List */

2017-08-29T19:53:59Z

OpenCart Feature And Capabilities Wish List

Ted: 2017-08-29 - Ted starting OpenCart features and capabilities to-do and wish-list page

2017-08-29T11:33:31Z

2017-08-29 - Ted starting OpenCart features and capabilities to-do and wish-list page

New page

== OpenCart Feature And Capabilities Wish List ==

- 2017-08-29 -

OpenCart 2.x administrative web interface has a lot of nice features, but the product adding and editing page has only limited product filtering. Would be useful to be able to amend the product-filtering options beyond the six product attributes shown on this page in OC 2.x. As first step in locating the PHP script or scripts responsible for generating this admin interface, here Ted posts the HTML code which creates the six-count input form for filtering products . . .

<i>Figure x - HTML excerpt of OpenCart 2.x "edit products" administrative web interface:</i>

<pre>

<div class="panel-body">
<div class="well">
<div class="row">
<div class="col-sm-4">
<div class="form-group">
<label class="control-label" for="input-name">Product Name</label>
<input type="text" name="filter_name" value="" placeholder="Product Name" id="input-name" class="form-control" />
</div>
<div class="form-group">
<label class="control-label" for="input-model">Model</label>
<input type="text" name="filter_model" value="" placeholder="Model" id="input-model" class="form-control" />
</div>
</div>
<div class="col-sm-4">
<div class="form-group">
<label class="control-label" for="input-price">Price</label>
<input type="text" name="filter_price" value="" placeholder="Price" id="input-price" class="form-control" />
</div>
<div class="form-group">
<label class="control-label" for="input-quantity">Quantity</label>
<input type="text" name="filter_quantity" value="" placeholder="Quantity" id="input-quantity" class="form-control" />
</div>
</div>
<div class="col-sm-4">
<div class="form-group">
<label class="control-label" for="input-status">Status</label>
<select name="filter_status" id="input-status" class="form-control">
<option value="*"></option>
<option value="1" selected="selected">Enabled</option>
<option value="0">Disabled</option>
</select>
</div>
<div class="form-group">
<label class="control-label" for="input-image">Image</label>
<select name="filter_image" id="input-image" class="form-control">
<option value="*"></option>
<option value="1">Enabled</option>
<option value="0">Disabled</option>
</select>
</div>
<button type="button" id="button-filter" class="btn btn-primary pull-right"><i class="fa fa-filter"></i> Filter</button>
</div>
</div>
</div>

</pre>

@@ Line 2: / Line 2: @@
-== OVERVIEW ==
+== [[#top|^]] OVERVIEW ==
 This wiki article, started 2017 August at Neela, a stash point for Ted's notes on OpenCart.  Notes include configuration and works in progress, and some notes on basic MYSQL queries to aid in data manipulations which OpenCart interface doesn't fully support . . .  - TMH
@@ Line 9: / Line 9: @@
-== Opencart Issues ==
+== [[#top|^]] Opencart Issues ==
 Orders not editable when product quantity reaches zero . . .
@@ Line 32: / Line 32: @@
 <!-- comment -->
-== OpenCart Feature And Capabilities Wish List ==
+== [[#top|^]] OpenCart Feature And Capabilities Wish List ==
 - 2017-08-29 -
@@ Line 107: / Line 107: @@
 <!-- comment -->
 == [[#top|^]] Useful Queries to OC Database ==

@@ Line 110: / Line 110: @@
-== Useful Queries to OC Database ==
+== [[#top|^]] Useful Queries to OC Database ==
 OpenCart 2.x web interface provides much control over store, product category and product records and attributes but falls shy of some useful query-and-update expressions.  Some of these queries include,
@@ Line 120: / Line 120: @@
 <li>  add "product to store B" record per "product in store A" record
 </ul>
 <!-- EOF -->

@@ Line 23: / Line 23: @@
 Key files changes are:
-  [cart_install_dir]/opencart-3p0p3p7/catalog/controller/product/category.php
+  [cart_install_dir]/catalog/controller/product/category.php
 ...and...

← Older revision		Revision as of 06:15, 19 October 2021
Line 16:		Line 16:

	* https://stackoverflow.com/questions/40828394/opencart-2-2-how-to-show-stock-per-option-with-zero-stock-also-showing		* https://stackoverflow.com/questions/40828394/opencart-2-2-how-to-show-stock-per-option-with-zero-stock-also-showing
		+
		+	2021 Q4 note: Opencart recent release is 3.0.3.7, a release which now incorporates [ Twig] template language and changes the somewhat the manner in which database queries by Opencart PHP scripts can be shared with the HTML output generating code. A useful Opencart forum post which gave key clue as to sharing product quantities with general product search results pages:
		+
		+	* https://forum.opencart.com/viewtopic.php?t=200892
		+
		+	Key files changes are:
		+
		+	[cart_install_dir]/opencart-3p0p3p7/catalog/controller/product/category.php
		+
		+	...and...
		+
		+	[cart_install_dir]/catalog/view/theme/default/template/product/category.twig

← Older revision		Revision as of 07:18, 17 November 2019
Line 14:		Line 14:

	* https://github.com/opencart/opencart/issues/3811		* https://github.com/opencart/opencart/issues/3811
		+
		+	* https://stackoverflow.com/questions/40828394/opencart-2-2-how-to-show-stock-per-option-with-zero-stock-also-showing

← Older revision		Revision as of 19:18, 16 November 2019
Line 9:		Line 9:


		+	== Opencart Issues ==
		+
		+	Orders not editable when product quantity reaches zero . . .
		+
		+	* https://github.com/opencart/opencart/issues/3811
		+
		+
		+	<!-- comment -->

	== OpenCart Feature And Capabilities Wish List ==		== OpenCart Feature And Capabilities Wish List ==

← Older revision		Revision as of 15:16, 7 September 2017
Line 1:		Line 1:
		+
		+
		+
		+	== OVERVIEW ==
		+
		+	This wiki article, started 2017 August at Neela, a stash point for Ted's notes on OpenCart. Notes include configuration and works in progress, and some notes on basic MYSQL queries to aid in data manipulations which OpenCart interface doesn't fully support . . . - TMH
		+
		+	<!-- comment -->


Line 76:		Line 84:


		+	<!-- comment -->
		+
		+
		+
		+	== Useful Queries to OC Database ==
		+
		+	OpenCart 2.x web interface provides much control over store, product category and product records and attributes but falls shy of some useful query-and-update expressions. Some of these queries include,
		+
		+
		+	<ul>
		+	<li> find all products not in any category (required MYSQL sub-query)
		+	<li> change product status per product category
		+	<li> add "product to store B" record per "product in store A" record
		+	</ul>


−	~~<!-- comment -->~~

	<!-- EOF -->		<!-- EOF -->

← Older revision		Revision as of 19:53, 29 August 2017
Line 59:		Line 59:

	</pre>		</pre>
		+
		+
		+	Ok narrowing a text search via <code>grep</code> called in OpenCart's installation directory, with <code>-r</code> recursive search option, leads to two results both in files of type 'tpl'. These may be template files of some kind. Have PHP developers a convention of writing template files and giving them .tpl extension? . . .
		+
		+	<pre>
		+
		+	ted@localhost:/var/wwwsite.com/public_html/opencart-2p3p0p2$ grep -n -r 'input type="text" name="filter_quantity"' ./*
		+
		+	./admin/view/template/catalog/product_list.tpl:52: <input type="text" name="filter_quantity" value="<?php echo $filter_quantity; ?>" placeholder="<?php echo $entry_quantity; ?>" id="input-quantity" class="form-control" />
		+
		+	./admin/view/template/extension/openbay/openbay_itemlist.tpl:122: <input type="text" name="filter_quantity" value="<?php echo $filter_quantity; ?>" class="form-control" placeholder="<?php echo $text_min; ?>" id="input-quantity" />
		+
		+	ted@localhost:/var/www/site.com/public_html/opencart-2p3p0p2$
		+
		+	</pre>
		+