Topics

When attempting to use either the SOURCE or the shell method of db update as provided here;
http://www.mysqlfaqs.net/mysql-faqs/Client-Server-Commands/How-to-run-SQL-script-files-in-mysql-client

the update sql script fails at both the --server line and the set @block_id line.

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--server
('server', 'config_upload_max_size', '16000'),
('server', 'config_store' at line 2
Query OK, 1 row affected (0.00 sec)

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@block_id' at line 1

~$ mysql --version
mysql  Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using readline 6.1

Is there a list of all the features and bugfixes that got addressed from 0.92 to 1.0 please.

You should keep a running list of information like this.

When you're entering the height, width, length and weight for a product should you enter the actual size, or the shipping box size?

Is the purpose here to give better stats to the user about the product, or the final boxed size that the various shipping modules can use to determine cost of freight?

Thanks

Create a product and give it a tag "test tag".  Now visit that products page and click the "test tag" tag, the search results return nothing because space gets turned into %20 in the URL which doesn't get url decoded back for the query..

I imagine other special characters would also fail.  Tags should be stripped of all special characters except only those legal as a tag in a url .

Again this is something I could have fixed for you if there was a git repo.. 

So is it safe for me to enter a bunch of real data into Abante?

I'm wondering if data migration from one version to the next can be assured at this point?

When listing products on the admin products page, I'd really like to be able to see the SKU.. 

To that end I'd suggest to create a way to make the visible columns editable by admin..

(Or, if you open up the source via git community developers can work on that for you =)

So what are the chances of getting a GIT repository so that developers like myself can help contribute?

The nice thing about git is that we can create feature branches, do something we think would be handy and then issue a pull request when we have it working.. you can then choose to merge it into the code base or not.  Most likely a lot of folks would end up committing code to the project this way  and so long as you make it clear that all code committed in this manner must be clean, dry and easy to understand it ends up being a win win for everyone..

Code Select Expand

mysql> select * from store.users;
+---------+---------------+-----------+----------------------------------+-----------+----------+-----------------------+--------+----------------+---------------------+---------------------+
| user_id | user_group_id | username  | password                         | firstname | lastname | email                 | status | ip             | date_added          | last_login          |
+---------+---------------+-----------+----------------------------------+-----------+----------+-----------------------+--------+----------------+---------------------+---------------------+
|       1 |             1 | palamedes | 2f28fea59aa3979397385178ea4a0051 | aaaaa     | bbbbb    | aaaaa.bbbbb@yahoo.com |      1 | 172.179.21.203 | 2012-03-06 13:22:19 | 2012-03-07 12:12:34 |
+---------+---------------+-----------+----------------------------------+-----------+----------+-----------------------+--------+----------------+---------------------+---------------------+
1 row in set (0.00 sec)

mysql> select * from secondstore.users;
+---------+---------------+-----------+----------------------------------+-----------+----------+-----------------------+--------+----------------+---------------------+---------------------+
| user_id | user_group_id | username  | password                         | firstname | lastname | email                 | status | ip             | date_added          | last_login          |
+---------+---------------+-----------+----------------------------------+-----------+----------+-----------------------+--------+----------------+---------------------+---------------------+
|       1 |             1 | palamedes | 2f28fea59aa3979397385178ea4a0051 | aaaaa     | bbbbb    | aaaaa.bbbbb@yahoo.com |      1 | 172.179.21.203 | 2012-03-06 13:22:19 | 2012-03-07 08:44:27 |
+---------+---------------+-----------+----------------------------------+-----------+----------+-----------------------+--------+----------------+---------------------+---------------------+
1 row in set (0.00 sec)



I have two installs store and secondstore.. both have identical admin accounts with the same password -- I made sure of this by updating the second stores table to be that of the first store..  Yet I can't login to the second store as it says no match for user name/password..  but it works fine on the first store.

Note; it was working fine before I did a backup of one store, and restored it to the other store to test those features.

Cache issue?

A system like this one will most likely inspire folks to add a lot of products.. With lots of products you will most likely get a lot of media in the form of images for each product.

Your system as it stands now creates 4 versions of each image in the form of thumbnails of various sizes.  So right there we have 4x the number of images actually uploaded.

And all of them live in image/thumbnails .. this is a bad idea .. It wont take long before this directory will bloat to ridiculous size..

Modern ext3 file system will allow you to have virtually an infinite number of entries so you are unlikely to run into the natural limit of the filesystem, but the more files you have in there the slower your file access time will be thus possibly adding a noticeable drag on page loads.   And you can't assume ext3 will be the file system.  NFS has a limit of 32k..

I would suggest each category or even each product getting it's own directory.. Currently images appear to be {productid/type}-{imageid}-{size}.extension

Probably not a bad idea to have the product id be a directory.

Create two installs of Abante Cart.  One will be your development or staging install, and one will be the production install.

Add a bunch of stuff to the develop install; categories, merchants, products, images etc..

Back up that "developer" install and restore it to the other "production" fresh install.  This should (and needs to) 100% work allowing you to migrate test on one machine and update to another production install.  It doesn't.

No media is backed up at all and should be -- copy/pasting the images directory structure over doesn't work either or rather only partially works.
Categories and Merchant (brand) listings on the page don't update likely due to some template caching issue.
Etc..

This area needs a lot of love.

MySQL allows for a random order of items..  It would be nice if we could have a sort by that uses "ORDER BY RAND()" for product category pages so that it shows a random listing.

It would be extremely nice (to the point that if you don't write it I'm going to add it) to have a flag in the product creation/editor page to "delist" or flip the status of a product to OFF when the number in stock reaches zero.

If you guys ever push AbanteCart out to git we can start adding these things in feature branches that you can pull into the main code base =)

[Test " Foo & Bar]

When an admin creates a category or product and they don't enter an SEO string you guys autogenerate one from the title and replace spaces with underscores.   Allow me to define that.  I should be allowed to use dashes, underscores or no spaces at all.  All are valid in the SEO world and each person has their preferences.. (I prefer dashes)

Note:  Right now if I enter  Test " Foo & Bar as my SEO string for something it converts to this; store.com/Test%20Category%20%22%20Foo%20&%20Bar

That's broken.  It should lower case it, convert the spaces to the users choice of dash, underscore or nothing, and strip all characters ^[a-zA-Z0-9]

Right now if an item comes up as "out of stock" you can still add it to your cart.. It does so with the *** telling you that the item is on back order or that it may not be in stock.

This is fine for products in which there are more than one, but for unique items (like hand crafted unique one of a kind items) it is less appropriate.  Instead it would be nice if we could flag a product/item as unique and the "Add to cart" button would be either removed entirely or replaced with an email button or some way to let a person ask about maybe getting another one similar to this item..

Currently products have a "date available" which I assume is when a product starts getting listed, but no end date.  It would be nice to be able to set an automatic termination date on products. 

Suggestions:

1.  Product options that augment price via a flat dollar rate or percentage should have that augmented amount listed as + $ or + %, not just the $ or %.

2.  Product options should be able to augment price both up and down.  I should be able to set an option that reduces a price.  (That price should then be shown as - % or - % )

3.  Product option values need to have the select box wider in the admin area as right now it's the same width as the subtract stock and prefix select box which is too narrow.

4.  When setting a product option I should be able to set which of the values is default --- this is especially important with radio buttons and when you have it as "required"

Submitted some bugs around the display as it's kinda broken in a couple places.  The product options area needs some love =)

Is there currently a way (or a planned way in the future) to do customizable perma/pretty links using mod rewrite?

So I can have mystore.com/index.php?rt=index/home look like mystore.om/home?

Maybe something similar to what wordpress allows you to do?  (I hate comparing you to wordpress.. )

WordPress offers you the ability to create a custom URL structure for your permalinks and archives. This can improve the aesthetics, usability, and forward-compatibility of your links. A number of tags are available;  codex.wordpress.org/Using_Permalinks

I am seeing a couple bugs here and there.. do you have a dedicated place for us to post those?

Is it possible to edit/change the search bar menu that has the "special offers", "bookmarks", "contact"..etc.. links?  I'm not seeing it..