Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

241

Members
  • Posts

    6,154
  • Joined

  • Last visited

Everything posted by 241

  1. try this create a directory in your catalog called easypopulate and set the permissions to CHMOD 777 all rights to all things. Next change these two lines in easypopulate.php to this $tempdir = "/easypopulate/"; $tempdir2 = "/easypopulate/";
  2. Sorry that you feel the need to give up as this is an easy contribution to install. You will need to post your other questions in the general support forum as they are not related to this contribution and it's support channel.
  3. do you have products_featured in your products table in the database, if not run this sql to see if it produces any duplicate entry errors. Only run the sql if no products_featured field is in the products table of the database ALTER TABLE `products` ADD `products_featured` tinyint(1) default '0' AFTER `products_status`; ALTER TABLE `products` ADD `products_featured_until` date default NULL AFTER `products_date_available`; ALTER TABLE `categories` ADD `categories_featured_until` date default NULL AFTER `sort_order`; ALTER TABLE `categories` ADD `categories_featured` tinyint(1) default '0' AFTER `sort_order`; ALTER TABLE `manufacturers` ADD `manufacturer_featured_until` date default NULL AFTER `manufacturers_image`; ALTER TABLE `manufacturers` ADD `manufacturers_featured_until` date default NULL AFTER `manufacturers_image`; ALTER TABLE `manufacturers` ADD `manufacturers_featured` tinyint(1) default '0' AFTER `manufacturers_image`; ALTER TABLE `manufacturers` ADD `manufacturer_featured` tinyint(1) default '0' AFTER `manufacturers_image`; ALTER TABLE `products_description` ADD `products_short` TEXT AFTER `products_name`;
  4. check your tare weight in the admin left menu shipping/packaging in the configuration box
  5. Is it possible to track clicks on popup pages as well?
  6. It may be that the sql did not complete, try running this sql ALTER TABLE `manufacturers_info` CHANGE `manufacturers_id` `manufacturers_id` INT( 11 ) NOT NULL AUTO_INCREMENT; ALTER TABLE `manufacturers_info` CHANGE `languages_id` `languages_id` INT( 11 ) DEFAULT '1' NOT NULL; INSERT INTO configuration_group VALUES ('99', 'Featured Sets', 'Configure featured sets', 16, 1); INSERT INTO configuration VALUES ('', 'Display featured products', 'FEATURED_PRODUCTS_DISPLAY', 'true', 'Show featured products?', 99, 1, '2004-06-23 20:16:49', '2004-06-06 21:19:24', '', 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration VALUES ('', 'Layout position of featured products section', 'FEATURED_PRODUCTS_POSITION', '2', '1= Top<br>2= Top Middle<br>3= Bottom Middle<br>4= Bottom.<br>', 99, 2, NULL, '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''1'', ''2'', ''3'', ''4''),'); INSERT INTO configuration VALUES ('', 'Featured products maximum', 'MAX_DISPLAY_FEATURED_PRODUCTS', '2', 'How many featured products show?', 99, 3, '2004-06-22 18:16:16', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Columns in featured products layout', 'FEATURED_PRODUCTS_COLUMNS', '2', 'How many columns do you want to use in your layout?', 99, 4, '2004-06-28 23:23:35', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Words per short description when it''s not written', 'MAX_FEATURED_WORD_DESCRIPTION', '24', 'When you don''t enter short description, truncate description upto how many words?', 99, 5, '2004-06-06 21:41:43', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Featured products period', 'DAYS_UNTIL_FEATURED_PRODUCTS', '2', 'How many days do you want to add to the current date when you click on the green light.', 99, 6, '2004-06-23 18:15:33', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Choose a featured products set layout', 'FEATURED_SET', '3', '1= side by side<br>2= over under<br>3= image, price over under, description side<br>4= image, price over under', 99, 7, '2004-06-28 23:23:04', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_featured(array(''1'', ''2'', ''3'', ''4''),'); INSERT INTO configuration VALUES ('', 'Choose a featured products set style', 'FEATURED_SET_STYLE', '4', '1= plain<br>2= boxed<br>3= lined<br>4= shadowboxed', 99, 8, '2004-07-12 12:20:27', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_featured(array(''1'', ''2'', ''3'', ''4''),'); INSERT INTO configuration VALUES ('', 'Set the direction of the shadow', 'FEATURED_SET_STYLE_SHADOW', 'left', 'right or left', 99, 9, '2004-07-12 12:24:42', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''right'', ''left''),'); INSERT INTO configuration VALUES ('', 'Set the sort order for the feature products.', 'FEATURED_PRODUCTS_SORT_ORDER', 'p.products_id', '<br><b>product id, <br>product name, <br>product price, <br>random.</b><br>', 99, 10, '2004-06-10 23:54:40', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''p.products_id'', ''pd.products_name'', ''p.products_price'', ''rand()''),'); INSERT INTO configuration VALUES ('', 'Set the sort order for products by ascending or descending', 'FEATURED_PRODUCTS_DIRECTION', 'DESC', 'ASC=ascending or DESC=descending', 99, 11, '2004-06-10 23:54:59', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''ASC'', ''DESC''),'); INSERT INTO configuration VALUES ('', 'Products vertical line height', 'VLINE_IMAGE_HEIGHT', '240', 'Sets the height of the vertical line divider', 99, 12, '2004-06-10 17:49:09', '0000-00-00 00:00:00', NULL, NULL); INSERT INTO configuration VALUES ('', 'Products vertical line colour', 'VLINE_IMAGE_COLOUR', 'blue', 'Sets the colour of the divider to:<br><br>black, white, silver, gold, red,<br>orange, green, yellow, blue or violet.', 99, 13, '2004-06-10 16:51:31', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''black'', ''white'', ''silver'', ''gold'', ''red'', ''orange'', ''yellow'', ''green'', ''blue'', ''violet''),'); INSERT INTO configuration VALUES ('', 'Products horizontal line colour', 'HORIZONTAL_LINE_COLOUR', 'f8fd69', 'Sets the colour of the horizontal line.<br><br>Enter a six digit hex number.<br>', 99, 14, '2004-06-10 17:11:42', '0000-00-00 00:00:00', NULL, NULL); INSERT INTO configuration VALUES ('', 'Display featured manufacturers', 'FEATURED_MANUFACTURERS_DISPLAY', 'true', 'Show featured manufacturers?', 99, 15, '2004-06-23 20:16:58', '2004-06-06 21:19:24', '', 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration VALUES ('', 'Layout position of featured manufacturers', 'FEATURED_MANUFACTURERS_POSITION', '1', '1= Top<br>2= Top Middle<br>3= Bottom Middle<br>4= Bottom.<br>', 99, 16, NULL, '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''1'', ''2'', ''3'', ''4''),'); INSERT INTO configuration VALUES ('', 'Featured manufacturers maximum', 'MAX_DISPLAY_FEATURED_MANUFACTURERS', '6', 'How many featured manufacturers to show?', 99, 17, '2004-06-23 22:45:27', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Columns in featured manufacturers layout', 'FEATURED_MANUFACTURERS_COLUMNS', '6', 'How many columns do you want to use in your layout?', 99, 18, '2004-06-23 22:45:32', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Set the sort order for the featured manufacturers.', 'FEATURED_MANUFACTURERS_SORT_ORDER', 'm.manufacturers_id', '<br><b>manufacturers id, <br>manufacturers name, <br>random.</b><br>', 99, 19, '2004-06-23 12:49:16', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''m.manufacturers_id'', ''m.manufacturers_name'', ''rand()''),'); INSERT INTO configuration VALUES ('', 'Set the manufacturers sort order by ascending or descending', 'FEATURED_MANUFACTURERS_DIRECTION', 'DESC', 'ASC=ascending or DESC=descending', 99, 20, '2004-06-10 23:54:59', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''ASC'', ''DESC''),'); INSERT INTO configuration VALUES ('', 'Manufacturers vertical line height', 'MANUFACTURERS_VLINE_IMAGE_HEIGHT', '110', 'Sets the height of the vertical line divider', 99, 21, '2004-06-23 22:26:18', '0000-00-00 00:00:00', NULL, NULL); INSERT INTO configuration VALUES ('', 'Manufacturers vertical line colour', 'MANUFACTURERS_VLINE_IMAGE_COLOUR', 'red', 'Sets the colour of the divider to:<br><br>black, white, silver, gold, red,<br>orange, green, yellow, blue or violet.', 99, 22, '2004-06-11 19:59:35', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''black'', ''white'', ''silver'', ''gold'', ''red'', ''orange'', ''yellow'', ''green'', ''blue'', ''violet''),'); INSERT INTO configuration VALUES ('', 'Manufacturers horizontal line colour', 'MANUFACTURERS_HORIZONTAL_LINE_COLOUR', 'AABBDD', 'Sets the colour of the horizontal line.<br><br>Enter a six digit hex number.<br>', 99, 23, '2004-06-19 16:39:39', '0000-00-00 00:00:00', NULL, NULL); INSERT INTO configuration VALUES ('', 'Featured manufacturers period', 'DAYS_UNTIL_FEATURED_MANUFACTURERS', '2', 'How many days do you want to add to the current date when you click on the green light.', 99, 24, '2004-06-23 18:15:40', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Display featured manufacturer with products', 'FEATURED_MANUFACTURER_DISPLAY', 'true', 'Show featured manufacturer with products?', 99, 25, '2004-06-19 20:08:08', '2004-06-06 21:19:24', '', 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration VALUES ('', 'Layout position of featured manufacturer with products', 'FEATURED_MANUFACTURER_POSITION', '3', '1= Top<br>2= Top Middle<br>3= Bottom Middle<br>4= Bottom.<br>', 99, 26, NULL, '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''1'', ''2'', ''3'', ''4''),'); INSERT INTO configuration VALUES ('', 'Featured manufacturer with products maximum', 'MAX_DISPLAY_FEATURED_MANUFACTURER', '2', 'How many featured manufacturer with products show?', 99, 27, '2004-06-23 22:24:58', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Columns in manufacturer with products layout', 'FEATURED_MANUFACTURER_COLUMNS', '2', 'How many columns do you want to use in your layout?', 99, 28, '2004-06-19 20:09:15', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Words per short description when it''s not written', 'MAX_FEATURED_MANUFACTURER_WORD_DESCRIPTION', '24', 'When you don''t enter short description, truncate description upto how many words?', 99, 29, '2004-06-06 21:41:43', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Featured manufacturer with products period', 'DAYS_UNTIL_FEATURED_MANUFACTURER', '2', 'How many days do you want to add to the current date when you click on the green light.', 99, 30, '2004-06-23 18:15:50', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Choose a featured manufacturer with products set layout', 'FEATURED_MANUFACTURER_SET', '3', '1= side by side<br>2= over under<br>3= image, price over under, description side<br>4= image, price over under', 99, 31, '2004-06-23 22:24:43', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_featured(array(''1'', ''2'', ''3'', ''4''),'); INSERT INTO configuration VALUES ('', 'Choose a featured manufacturer with products set style', 'FEATURED_MANUFACTURER_SET_STYLE', '3', '1= plain<br>2= boxed<br>3= lined<br>4= shadowboxed', 99, 32, '2004-07-12 12:38:14', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_featured(array(''1'', ''2'', ''3'', ''4''),'); INSERT INTO configuration VALUES ('', 'Set the direction of the shadow', 'FEATURED_MANUFACTURER_SET_STYLE_SHADOW', 'right', 'right or left', 99, 33, '2004-07-12 11:56:00', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''right'', ''left''),'); INSERT INTO configuration VALUES ('', 'Set the sort order for the feature manufacturer with products.', 'FEATURED_MANUFACTURER_SORT_ORDER', 'm.manufacturers_id', '<br><b>manufacturers id, <br>manufacturers name, <br>product id, <br>product name, <br>product price, <br>random.</b><br>', 99, 34, '2004-06-23 12:49:16', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''m.manufacturers_id'', ''m.manufacturers_name'', ''p.products_id'', ''pd.products_name'', ''p.products_price'', ''rand()''),'); INSERT INTO configuration VALUES ('', 'Set the manufacturer sort order by ascending or descending', 'FEATURED_MANUFACTURER_DIRECTION', 'DESC', 'ASC=ascending or DESC=descending', 99, 35, '2004-06-10 23:54:59', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''ASC'', ''DESC''),'); INSERT INTO configuration VALUES ('', 'Manufacturer with products vertical line height', 'MANUFACTURER_VLINE_IMAGE_HEIGHT', '150', 'Sets the height of the vertical line divider', 99, 36, '2004-06-23 22:26:04', '0000-00-00 00:00:00', NULL, NULL); INSERT INTO configuration VALUES ('', 'Manufacturer with products vertical line colour', 'MANUFACTURER_VLINE_IMAGE_COLOUR', 'blue', 'Sets the colour of the divider to:<br><br>black, white, silver, gold, red,<br>orange, green, yellow, blue or violet.', 99, 37, '2004-06-10 16:51:31', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''black'', ''white'', ''silver'', ''gold'', ''red'', ''orange'', ''yellow'', ''green'', ''blue'', ''violet''),'); INSERT INTO configuration VALUES ('', 'Manufacturer with products horizontal line colour', 'MANUFACTURER_HORIZONTAL_LINE_COLOUR', 'f8fd69', 'Sets the colour of the horizontal line.<br><br>Enter a six digit hex number.<br>', 99, 38, '2004-06-10 17:11:42', '0000-00-00 00:00:00', NULL, NULL); INSERT INTO configuration VALUES ('', 'Display featured categories', 'FEATURED_CATEGORIES_DISPLAY', 'true', 'Show featured categories?', 99, 39, '2004-06-19 20:08:08', '2004-06-06 21:19:24', '', 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration VALUES ('', 'Layout position of featured categories', 'FEATURED_CATEGORIES_POSITION', '4', '1= Top<br>2= Top Middle<br>3= Bottom Middle<br>4= Bottom.<br>', 99, 40, NULL, '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''1'', ''2'', ''3'', ''4''),'); INSERT INTO configuration VALUES ('', 'Featured categories maximum', 'MAX_DISPLAY_FEATURED_CATEGORIES', '4', 'How many featured categories show?', 99, 41, '2004-06-28 16:48:04', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Columns in featured categories layout', 'FEATURED_CATEGORIES_COLUMNS', '2', 'How many columns do you want to use in your layout?', 99, 42, '2004-06-19 20:09:15', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Words per short description when it''s not written', 'MAX_FEATURED_CATEGORIES_WORD_DESCRIPTION', '24', 'When you don''t enter short description, truncate description upto how many words?', 99, 43, '2004-06-06 21:41:43', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Featured categories period', 'DAYS_UNTIL_FEATURED_CATEGORIES', '2', 'How many days do you want to add to the current date when you click on the green light.', 99, 44, '2004-06-23 18:15:50', '2004-06-06 21:19:24', NULL, NULL); INSERT INTO configuration VALUES ('', 'Choose a featured categories set layout', 'FEATURED_CATEGORIES_SET', '3', '1= side by side<br>2= over under<br>3= image, price over under, description side<br>4= image, price over under', 99, 45, '2004-06-28 16:46:19', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_featured(array(''1'', ''2'', ''3'', ''4''),'); INSERT INTO configuration VALUES ('', 'Choose a featured categories set style', 'FEATURED_CATEGORIES_SET_STYLE', '3', '1= plain<br>2= boxed<br>3= lined<br>4= shadowboxed', 99, 46, '2004-07-12 12:37:44', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_featured(array(''1'', ''2'', ''3'', ''4''),'); INSERT INTO configuration VALUES ('', 'Set the direction of the shadow', 'FEATURED_CATEGORIES_SET_STYLE_SHADOW', 'right', 'right or left', 99, 47, '2004-07-12 11:56:00', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''right'', ''left''),'); INSERT INTO configuration VALUES ('', 'Set the sort order for the feature categories.', 'FEATURED_CATEGORIES_SORT_ORDER', 'c.categories_id', '<br><b>categories id, <br>categories name, <br>manufacturers id, <br>product id, <br>product name, <br>product price, <br>random.</b><br>', 99, 48, '2004-06-23 12:49:16', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''c.categories_id'', ''cd.categories_name'', ''m.manufacturers_id'', ''p.products_id'', ''pd.products_name'', ''p.products_price'', ''rand()''),'); INSERT INTO configuration VALUES ('', 'Set the categories sort order by ascending or descending', 'FEATURED_CATEGORIES_DIRECTION', 'DESC', 'ASC=ascending or DESC=descending', 99, 49, '2004-06-10 23:54:59', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''ASC'', ''DESC''),'); INSERT INTO configuration VALUES ('', 'Categories vertical line height', 'CATEGORIES_VLINE_IMAGE_HEIGHT', '150', 'Sets the height of the vertical line divider', 99, 50, '2004-06-23 22:26:04', '0000-00-00 00:00:00', NULL, NULL); INSERT INTO configuration VALUES ('', 'Categories vertical line colour', 'CATEGORIES_VLINE_IMAGE_COLOUR', 'green', 'Sets the colour of the divider to:<br><br>black, white, silver, gold, red,<br>orange, green, yellow, blue or violet.', 99, 51, '2004-06-28 16:29:02', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(''black'', ''white'', ''silver'', ''gold'', ''red'', ''orange'', ''yellow'', ''green'', ''blue'', ''violet''),'); INSERT INTO configuration VALUES ('', 'Categories horizontal line colour', 'CATEGORIES_HORIZONTAL_LINE_COLOUR', 'dcab89', 'Sets the colour of the horizontal line.<br><br>Enter a six digit hex number.<br>', 99, 52, '2004-06-28 16:27:32', '0000-00-00 00:00:00', NULL, NULL);
  7. I don't see any issues here merge the two parts, in this case the header tags part into the featured sets part by adding this into the query , pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag,
  8. Does the product have attribute options? If product has attributes options it will go to product_info.php If product does not have attributes options it will go to shopping_cart.php
  9. is your temp directory in the catalog directory or the admin
  10. Header Whitespace download the file catalog/includes/functions/general.php open it and place your cursor after the last ?> then press delete several times, save the file and upload it. Do not use the file manager to edit online as this can cause the whitespace. instead use an ftp program such as ws_ftp to download the file to a local machine and edit then upload using the ftp program If you require more information then Click
  11. you could add an entry to the database, to give you an entry section in admin. Then use an array statement
  12. you already have an entry in the database with the configuration_group_id value of 30 the resolve is to change the sql to be INSERT INTO `configuration_group` ( `configuration_group_id` , `configuration_group_title` , `configuration_group_description` , `sort_order` , `visible` ) VALUES ( '', 'Current Auctions', 'Current Auction configuration', 30, 1 );
  13. Yes, you should run the sql from the point of original fault ALTER TABLE `manufacturers_info` CHANGE `manufacturers_id` `manufacturers_id` INT( 11 ) DEFAULT '0' NOT NULL AUTO_INCREMENT replacing this line with the ammended line ALTER TABLE `manufacturers_info` CHANGE `manufacturers_id` `manufacturers_id` INT( 11 ) NOT NULL AUTO_INCREMENT;
  14. this previous post has the answer http://www.oscommerce.com/forums/index.php?sho...ndpost&p=612729
  15. yes instead of replacing the code from your previous question you would add the code line below so as to be <tr> <td><?php include(DIR_WS_MODULES . FILENAME_FEATURED_SETS); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td> </tr>
  16. if this is whilst going through the checkout then it will probably be due to your settings for Shipping/Packaging in the admin left menu under configuration and would be due to having no entry for Enter the Maximum Package Weight you will ship
  17. possibly this post may help http://www.oscommerce.com/forums/index.php?sho...ndpost&p=413494 Once you have set this in the catalog/index.php you should just need to set the products that you want to be featured as featured status active and they will show.
  18. As the instructions state you will need to modify the calls as shown in the examples mentioned in all the information below ?HERE?
  19. you would need to alter the query used in advanced_search_result.php to reflect the salemaker price coding.
  20. you could do this using the product attributes section in the admin in a similar fashion to how the options are done for size, colour, or in the case of the defaults for the graphics card memory adding the additional cost to the attribute.
  21. check your txt file that it shows the category as being 17_1 and not 17_xxx
  22. you mention new txt file this would suggest to me that you are using easypopulate and that this is what is causing your issue. When entering a new product for that sub category do you copy and paste from an existing one and then ammend the details or do you enter all the data from scratch, what do you do with the sub category number do you incriment it each time
  23. the long method is to open each sub category and move the product to the first sub category called GAMES - ACTION, ARCADE & SHOOTERS then delete the empty sub category.
  24. without being able to see the admin and just going on what information you have given, my guess would be that the sub category has been copied each time and then the product edited or added. In your admin do you have 506 sub categories by the name GAMES - ACTION, ARCADE & SHOOTERS each containing 1 product or do you have just the one sub category named GAMES - ACTION, ARCADE & SHOOTERS containing all 506 products?
×
×
  • Create New...