Search found 19 matches

Page 1 of 1

Search found 19 matches

Re: sql query total price of all the products for sale in a

Ignoring specials, something like this should work: echo $this->db->query("select CONCAT('$', FORMAT(sum(quantity * price), 2)) as total_stock_amt from " . DB_PREFIX . "product")->row['total_stock_amt']; Taking specials into account: echo $this->db->query(" select CONCAT('$', FORMAT(sum(p.`quantity`...

Jump to post
  • Fri Jun 07, 2013 2:07 am
  • Replies 2
  • Views 664
Re: Import/Export Tool (Free) Filters?

If you export your product data to a spreadsheet, you can then update the filter info under the Attributes tab, and then save and import. For example, aside from price, I have two other filters ("Per Pack" and "Container Size") both belonging to the "Details" Attribute Group. So my spreadsheet.Attri...

Jump to post
  • Fri Jun 07, 2013 12:59 am
  • Replies 2
  • Views 1076
Re: Sub Categories

Looks like you've got it working now : )

Jump to post
  • Fri Jun 07, 2013 12:22 am
  • Replies 1
  • Views 100
Re: How to get a specific attribute value string using php ?

In the admin product page, your attributes can be found in array $product_attributes. And in the catalog product page, they can be found in array $attribute_groups. So, If you just want to see it on your front end product page, I would suggest adding this in catalog/view/theme/default/template/produ...

Jump to post
  • Sun Jun 02, 2013 12:12 pm
  • Replies 6
  • Views 7339
Re: Filter module opencart 1.5.5.1 - Guide?

Q000 , Thank you - Your code is a 'must have'! SteitSlings , Thank You - That is perfect! Nicusor (azzido) , I will check this thread several times a day until you say your problem is solved. If you would prefer a vQmod for this, just let me know. I'm pretty sure the error message you're seeing has...

Jump to post
  • Tue May 28, 2013 1:29 pm
  • Replies 109
  • Views 96084
Re: let the category tree open

To open up all of the categories, simply
comment-out line 741 in catalog/view/theme/default/stylesheet/stylesheet.css

from:

Code: Select all

ul.box-category > li ul {
	display: none;
}
to:

Code: Select all

ul.box-category > li ul {
/*	display: none;	*/
}
Hope that helps.

Regards,
Midgette

Jump to post
  • Fri May 24, 2013 11:12 am
  • Replies 1
  • Views 392
Re: How can I change spaces between products in Featured Pro

Here's one way: Admin > System > Settings > {your store} > Edit > Image Tab > Then Increase the size of : Category Image Size, Product Image Thumb Size, Additional Product Image Size, Related Product Image Size and Compare Image Size to 120 x 120 for starters....then see how it looks and adjust ...R...

Jump to post
  • Fri May 24, 2013 9:50 am
  • Replies 4
  • Views 787
Re: Extension / Hack wanted - Happy To Pay

Hi Steve, I just realized that, you might have pending orders...If you do, then before installing this extension, you should run this query on your database (this assumes your database prefix is "oc_"): UPDATE oc_order_product SET inv_group = (SELECT inv_group FROM oc_product WHERE product_id = oc_o...

Jump to post
  • Fri May 24, 2013 1:20 am
  • Replies 8
  • Views 2119
Re: Extension / Hack wanted - Happy To Pay

Hi Steve,
I'll make you a vQmod for this. If you can tell me all of the vQmod extensions that you are using, I can make sure that this doesn't step on any of them, or vice versa.

Regards,
Midgette

Jump to post
  • Thu May 23, 2013 3:16 am
  • Replies 8
  • Views 2119
Re: Extension / Hack wanted - Happy To Pay

Hi Steve, Two things about testing that I should have mentioned: 1. After seeing that a purchase has correctly adjusted the inventory quantities for all items in the associated group(s), go into Admin > Sales > Orders and edit the order's status from "Pending" to "Completed". Then verify that the in...

Jump to post
  • Wed May 22, 2013 12:43 pm
  • Replies 8
  • Views 2119
Re: How do I remove duplicated categories in Sitemap?

Great. Not sure exactly which extensions you have...but none of the "Tellafriend" and "FAQ" extensions that I've seen add themselves into the sitemap. I agree with your idea that they should. I bet if you ask the developers of those extensions, they would help make those changes - each would probabl...

Jump to post
  • Mon May 20, 2013 1:59 pm
  • Replies 6
  • Views 913
Re: Tax Calculations on 1.5.1.1

..and Salutations! I would imagine by now you have found either the solution or a fix for this problem. The solution is built into opencart as it lets you configure shipping as taxable or non-taxable. You would do this by first navigating through Admin > Extensions > Shipping > {your various enabled...

Jump to post
  • Sat May 18, 2013 12:59 pm
  • Replies 2
  • Views 365
Re: How do I remove duplicated categories in Sitemap?

Ah, I THINK I understand now.... To remove these: sm-not.jpg from JUST your sitelist, assuming you have version 1.5.5.1, you can change line 12 in catalog/view/theme/default/template/information/sitemap.tpl from: <?php foreach ($categories as $category_1) { ?> <?php foreach ($categories as $category...

Jump to post
  • Sat May 18, 2013 2:45 am
  • Replies 6
  • Views 913
Re: How do I remove duplicated categories in Sitemap?

I'm pretty sure you will want to delete categories 90,91,92,93,94,95,96,98,99,101,102,103,104,105,106,107,109,110,111 and 112. Then look at catalog/view/theme/default/template/product/category.tpl. I believe you changed something between lines 21 - 41 because this is what makes your sub-categories a...

Jump to post
  • Fri May 17, 2013 2:38 pm
  • Replies 6
  • Views 913
Re: How do I remove duplicated categories in Sitemap?

Mousing over Antiques on the left side I see the url is: swdvariety.com/index.php?route=product/category&path=90 (90 is a category_id). And mousing over Products > Antiques in the menu, the url is: swdvariety.com/index.php?route=product/category&path=59_68 (68 is a sub-category under category 59). Y...

Jump to post
  • Fri May 17, 2013 1:48 pm
  • Replies 6
  • Views 913
Re: Extension / Hack wanted - Happy To Pay

Hi Steve, I can help you with this. If you are using the Excel Import/Export extension, just let me know because we will need to make some additional changes. If you would prefer an installation script to the following, just let me know. Otherwise: First, backup your system . Then, using something l...

Jump to post
  • Fri May 17, 2013 12:05 pm
  • Replies 8
  • Views 2119
Re: Filter module opencart 1.5.5.1 - Guide?

Q,
Thank You for your kind words!
Glad I could help : )

Best Regards,
midgette

Jump to post
  • Fri May 03, 2013 1:22 pm
  • Replies 109
  • Views 96084
Re: Filter module opencart 1.5.5.1 - Guide?

I needed a filter that would use OR logic for items within each filter group and, at the same time, use AND logic on the groups of filters. For example, i needed to select red or blue or green shirts that are large. Pseudo code: (filter_group_color.filter = 'red' OR filter_group_color.filter = 'blue...

Jump to post
  • Sun Apr 28, 2013 4:42 pm
  • Replies 109
  • Views 96084

Page 1 of 1

Search found 19 matches