AbleCommerce Shopping Cart Software

That's not quite what I'm interested in. That field is where a customer can leave a note about the product when they order it. I want to see all of the notes left in that box for a particular item.

Is the value users enter into that field stored in the database somewhere?

Where is the item notes field stored in the database? I'm not sure what the field is named, so I've included a screenshot. https://www.dropbox.com/s/ty98ldl54fyyzvf/notes_field.PNG?raw=1 What table in the database is the value of that field stored in? I am hoping to query the database to see all of ...

I'm not sure what's going on, but I'll share what our developers have found. What would explain what the developer describes below? Let’s take category Dairy > Milk Products > Coffee Creamers In the Database for catalog nodes you have this https://www.dropbox.com/s/gzakcvf741ftzyu/catalog-nodes.png?...

I'm getting this error when using the Delete button via the Categories admin page, not directly from the database.

I have a batch of around 1800 items that I want to restrict to a certain group. I've created the group and I know it's ID and I also know the productIDs of the 1800 items I want to add to this group. What is the best way to add all of those items to a group. I should add that many of these items are...

We've had our AC developer looking into this issue, and they've discovered: There is a table called catalog-nodes and it holds references to categories and their sub-categories and products. When you delete a product from a category, it deletes the product but not the record in the catalog nodes tab...

I'm My guess, is that you have a data integrity issue. You should not have been able to insert multiple product ID's in the database. There should be one unique product ID that can be associated to multiple categories. I think you're right. Is solving those issues something we could use the AbleComm...

Yes. I'm actually seeing the same behavior when I'm able to delete categories. I'm still having the issue where some categories simply can't be deleted though.

I can't seem to figure out yet, why some can be deleted and others cannot.

Okay. So that means we have many products in two or more categories.

Would that lead to not being able to delete a category if an item in that category was also in another category? I would hope not.

I was able to delete the duplicate items without issue. What I find strange is that even though four items shared the same product ID, I still had to manually delete all three. Also, can you tell me if this option Update to categories specified in uploaded data in the Data import wizard moves the pr...

Yes, there are four items listed in the Orphaned Items report. I think I am starting to understand our issue. We did a an item update using the data import feature where we changed the visibility and category for nearly every item in our store. We also added new categories via the import. However, i...

Thanks, Katie.

Is there away I can view Ref. Bug report AC8-3175 and follow progress on its resolution?

What version are you using? We are using AbleCommerce GoldR9 (build 7670) Are there products and/or sub-categories within the category you are trying to delete? There are both products and sub-categories in the categories I am trying to delete. I've also tried deleting the sub-categories first, but...

I am getting an exception when deleting categories. I am using the Red Circled X Delete button on the Browse Catalog page. I don't get in when deleting every category, but is occurring on the majority of them. The exception is: An error has occured at https://go.storetodoor.org/Admin/Catalog/Browse....

Is there a limit to the number of categories/sub-categories in a store? Right now when I try to view the Categories tab in the product editor I get a timed out exception. Our developers says the request is timing out when trying to load all of the categories as a tree. I have tried deleting categori...

Thanks. This looks very doable.

Is there a way to enable group restrictions for all products currently in the store? We are using AbleCommerce GoldR9 (build 7670) and have an item database of ~60K items. I'm hoping there is a way to enable group restrictions for all items. We have the groups set up already. I looked into the batch...

On average they take around 12 seconds to load once they reach that size. Our developer and host "rebuilt the indexes" on our database this morning to address a similar issue with search results, and it seems to have fixed the issue with Wishlists as well.The developer said he saw that there was a d...

In our store we have several users with wishlists of 60 or more items. It seems once a list starts to approach that size that the list page loads very slowly.

We are using AbleCommerce GoldR9 (build 7670).

Does anyone have recommendations for increasing the page load speed for wishlists?

I am trying to write a SQL query that will allow me to view product sales that includes categories. We are using R9(build 7670). I've looked at the AC 7 schema and understand that it is very similar to the Gold schema, but I don't see a relation between categories and products. Is it possible to mak...