Claudia M

Ok Thanks again Brian! The category_prefix column will be sortable in admin/products. Does it need to have an index? If so, what info should I give it? Nevermind ... I looked it up. Thank you again Brian for all your knowledge and help

Thanks Brian, I'll get on that ASAP When you say some of the columns will be empty do you mean the columns I will never use that are stock with CubeCart or the example from above about if the item doesn't come in a box it won't use the box_size column?

Attributes is the column next to collation in Cpanel with a drop down of binary,unsigned,unsigned-zerofill,and on update CURRENT_Timestamp. When you click change on a column " You might also find MySQL complain of a non-null column not having a default value to use. This will then require you to make very sure a data value is supplied for this column when INSERTing a new record. " - Not ALL products will have data in every column. For ex. if an item doesn't come in a box, box_size will not have data. So should I mark null yes or no? " You might also find MySQL complain of a non-null column not having a default value to use. This will then require you to make very sure a data value is supplied for this column when INSERTing a new record. " Here's some of mine " Depending how many items are in CubeCart_inventory, a KEY (INDEX) for each new column may prove useful, especially if you want to find a given value, or to sort on it." This is what I have:

Hi, I've added some columns to my inventory database and have a total of 73. Many of them are CubeCart core and not used. Ex. the dimensions and all that go with it, and the upn,ean,jan etc.... I've commented out the code for them in the admin/skins/product file. On the columns I've added I've used. Is this ok? Thanks in advance for any and all responses Type: varchar (30) SEE EACH collaltion: ut8_unicode_ci Null: no Default: none Attributes: Blank

Thank you Brian!

What does this portion of admin/sources/products.index.inc.php do? If I add new columns to the inventory database do I have to add info here too? Thanks in advance for all help. Me // Sorting $current_page = currentPage(array('sort')); if (!isset($_GET['sort']) || !is_array($_GET['sort'])) { $_GET['sort'] = array('updated' => 'DESC'); } $thead_sort = array ( 'status' => $GLOBALS['db']->column_sort('status', $lang['common']['status'], 'sort', $current_page, $_GET['sort']), 'digital' => $GLOBALS['db']->column_sort('digital', $lang['common']['type'], 'sort', $current_page, $_GET['sort']), 'image' => $lang['catalogue']['title_image'], 'name' => $GLOBALS['db']->column_sort('name', $lang['catalogue']['product_name'], 'sort', $current_page, $_GET['sort']), 'product_code' => $GLOBALS['db']->column_sort('product_code', $lang['catalogue']['product_code'], 'sort', $current_page, $_GET['sort']), 'price' => $GLOBALS['db']->column_sort('price', $lang['common']['price'], 'sort', $current_page, $_GET['sort']), 'stock_level' => $lang['catalogue']['title_stock'], 'updated' => $GLOBALS['db']->column_sort('updated', $lang['catalogue']['title_last_updated'], 'sort', $current_page, $_GET['sort']), 'translations' => $lang['translate']['title_translations'] ); foreach ($GLOBALS['hooks']->load('admin.product.table_head_sort') as $hook) include $hook; $GLOBALS['smarty']->assign('THEAD', $thead_sort);

Sent

Thanks Brian

Hey Brian, You had given me some code for this for my CC5 store. I'm still using it for my CC6.2.1 store. Is there anyway this can be made into a plugin so I don't have to keep changing the core code for each upgrade? It showed previous next buttons for each item in a category. Topic 51510 dated July 19, 2016. Example Thanks in advance, Claudia

Hey Notly1988 .... What is the URL of your store? Our database names are the same. What are the odds!

Wow Brian!!! Thank you for this! I'll implement it and let you know how it does. The small view looks great - no extra product. But on my laptop the last product is also gone. It is only showing 8 products instead of 9.. I cleared the cache

Thanks for all the input. I think I'll leave it as is - not require registration

Right now I do not require customers to register. I just looked at my customer list and it seems to be about half and half. Most, not all, of the items I sell are vintage one of a kind items. I use PayPal and PayPal Pro only for payment options. I wanted to put a link in the header for the customer to be able to lookup their order, but they have to be registered to do this don't they? I guess I could put an explanation that this is only available for registered customers.

I would welcome all points of view on this. Pros and Cons of requiring all customers to register on your site. Do you lose sales? thanks for all comments.

Yes that would work fine