Re: Shipping rates based upon postal codes?
Yes, I am now thinking that it does indeed make sense to create a new extension module for Australia shipping which will use additional MySQL tables for the for postcode ranges and the parcel distance charges.
Jump to post- Sun Feb 03, 2008 11:07 pm
- Replies 9
- Views 6043
Shipping rates based upon postal codes?
Is it possible to set up a shipping module based upon rates according to weights and geo_zones, where the geo_zone really is a postcode range. This is basically how the Australia Post charges for regular parcels. OpenCart zones are being used both as part of the address and shipping, but they are on...
Jump to post- Sun Feb 03, 2008 3:17 am
- Replies 9
- Views 6043
Re: How do I set up weight or zone-based shipping rates?
I think I now understand how it works. Thanks for your help.
I am now re-defining the zones and geo-zones for Australia according to the Australia Post destination zones and will also enter the correct distance weights per KG for these zones.
- Thu Jan 31, 2008 2:11 am
- Replies 2
- Views 2205
How do I set up weight or zone-based shipping rates?
How can I set up up weight-based and/or zone-based shipping? It is for an OpenCart based website whose market place is in Australia only. I am a little bit lost and can't seem to find any obvious admin pages for setting up shipping zones (e.g. all of the Australian states) and the shipping charges f...
Jump to post- Tue Jan 29, 2008 5:42 am
- Replies 2
- Views 2205
Re: Sub-Categories should be listed by sort_order first
Thanks, I wasn't aware of it.
I have now posted another bug with a proposed fix on that site.
See http://forum.opencart.com/index.php/topic,872.0.html and
http://code.google.com/p/open-cart/issues/detail?id=24 for more details.
- Sun Jan 27, 2008 7:38 pm
- Replies 2
- Views 1458
Sub-Categories should be listed by sort_order first
Sub-Categories should always be listed in the specified sort_order first. I changed the code in file catalog/controller/category.php in method index as follows on my server: ..... $results = $database->getRows("select * from category c left join category_description cd on (c.category_id = cd.ca...
Jump to post- Sat Jan 26, 2008 2:33 am
- Replies 2
- Views 1458
Re: Downloads File Fatal Error!
BTW, line 141 in shop/catalog/controller/account_download.php says: $response->redirect($url->ssl('account_download')); Do I need an SSL certificate to use the Downloads? I don't think so. It only uses SSL if it has been configured to do so, and if the HTTPS_SERVER has been defined in the config.php.
Jump to post- Sat Jan 26, 2008 2:03 am
- Replies 5
- Views 1611
Re: Results always off by one!
OK, Here is how to fix it: In file library/database/database.php , within the method splitQuery , replace the line containing $this->from = (int)(($offset > 0 || $count['total'] == 0) ? $offset : '1'); with the corrected one: $this->from = (int)(($offset > 0 || $count['total'] == 0) ? $offset+1 : ...
Jump to post- Fri Jan 25, 2008 6:46 pm
- Replies 2
- Views 861
Results always off by one!
It seems no one has noticed that before. When, for a given category, the products are splitted up accross multiple pages, e.g. '1 of 12', '2 of 12', ...,'12 of 12', the text_results is wrong: For example: '1 of 12' shown as 'Results 1 - 9 of 100' '2 of 12' shown as 'Results 9 - 18 of 100' instead of...
Jump to post- Fri Jan 25, 2008 6:17 pm
- Replies 2
- Views 861
Help! Getting 'Too many connections' errors
Am I the only one getting the 'Too many connections' error messages? Warning: mysql_connect() [function.mysql-connect]: Too many connections in /home/vcsprodu/public_html/library/database/database.php on line 16 Is there a way to reduce the number of connections to MySQL in OpenCart? Is it just bad ...
Jump to post- Thu Jan 24, 2008 5:38 pm
- Replies 0
- Views 767
Re: Too many connections?
Also, there doesn't seem to be any calls to the mysql_close function, again causing a rapid increase of new connections for each new request.
Jump to post- Wed Jan 23, 2008 5:05 am
- Replies 2
- Views 1565
Too many connections?
I frequently got a Warning: mysql_connect() [function.mysql-connect]: Too many connections in /home/vcsprodu/public_html/library/database/database.php on line 16 error message on my new website running OpenCart 0.7.7. Am I correct in my understanding that OpenCart calls the mysql_connect function fo...
Jump to post- Wed Jan 23, 2008 4:21 am
- Replies 2
- Views 1565
Re: I need a product catalogues, what supporting different categories
In OpenCart, you can have a whole hierarchy of categories. Also, a product can belong to more than one product.
Jump to post- Mon Jan 21, 2008 3:29 am
- Replies 2
- Views 1744
Re: Bulk import/export of categories
Well I finished the Export/Import to/from Spreadsheet feature, see http://forum.opencart.com/index.php/topic,853.0.html . I am still struggling with the 255 character limitation when reading an uploaded XLS-file in PHP, once that problem is sorted out, I'll upload this addon as a free contribution. ...
Jump to post- Mon Jan 21, 2008 3:27 am
- Replies 16
- Views 9461
Re: Uploading a .csv File
The spreadsheet file will consist of 3 worksheets: Worksheet 'Categories': (column 'description' is optional, not in standard OpenCart database) category_id image_name image_title parent_id sort_order date_added date_modified language_id name description Worksheet 'Products': product_id name categor...
Jump to post- Mon Jan 21, 2008 3:20 am
- Replies 18
- Views 11111
Re: Uploading a .csv File
I hope to be able to upload the Import / Export addon to OpenCart very soon, see http://forum.opencart.com/index.php/topic,846.0.html on this. It uses the XLS format for this.
Jump to post- Sun Jan 20, 2008 10:23 pm
- Replies 18
- Views 11111
Re: Populating my shop database
I am planning to contribute an Import/Export module to OpenCart soon. If you can wait for few more days, you can use it. I am planning to upload it here. I have been using it for a live site which has about 1500 products and 175 categories. The only outstanding problem I need to resolve is that of l...
Jump to post- Sun Jan 20, 2008 10:20 pm
- Replies 4
- Views 2822
Re: Upload of large backup DB timeout
After further investigation I came to the conclusion that it must have been because of the large filesize. PHP was only configured to support up to 2 MBytes (upload_max_filesize "2M"). With PhpMyAdmin, it worked fine. Still, I changed the admin/controller/upload.php so that it will return ...
Jump to post- Sat Jan 19, 2008 12:21 am
- Replies 2
- Views 1301
Upload of large backup DB timeout
Hello Daniel, or anybody who could help! I have created a live site, with 150 categories and 1500 products, whose database backup file is about 4MBytes in size. When I try to restore the database from a locally saved backup file, using a ADSL line of 256kbps upload speed, via Opencart's Admin>Config...
Jump to post- Fri Jan 18, 2008 9:02 pm
- Replies 2
- Views 1301
Strange database design
I noticed that the 'product' table has a foreign key 'image_id' pointing to the 'image' table (one-to-one or many-to-one relationship). However, there is also a 'product_to_image' table for implementing a many-to-many relationship between 'product' and 'image' tables. Doesn't the latter make the 'im...
Jump to post- Tue Dec 25, 2007 4:35 am
- Replies 2
- Views 1763
