sigspace

can see front end files "create_account.php" and files inside "includes/modules/" that need changing. i remember reading on this forum about DB changes for 2.3.4 bootstrap, so are all of these update/insert SQL commands valid for the new 2.3.4 bootstrap DB? # UK Additions to the database follow SET NAMES latin1; UPDATE configuration SET configuration_value='222' WHERE configuration_key = 'SHIPPING_ORIGIN_COUNTRY'; UPDATE configuration SET configuration_value='222' WHERE configuration_key = 'STORE_COUNTRY'; UPDATE configuration SET configuration_value='0' WHERE configuration_key = 'STORE_ZONE'; UPDATE configuration SET configuration_value='GBP' WHERE configuration_key = 'DEFAULT_CURRENCY'; UPDATE tax_rates SET tax_rate=20.0000, tax_description='VAT (20%)' WHERE tax_rates_id=1; UPDATE geo_zones SET geo_zone_name='European Countries', geo_zone_description='EU VAT zone' WHERE geo_zone_id = 1; INSERT INTO address_format VALUES (NULL, '$firstname $lastname$cr$streets$cr$city$cr$postcode$cr$country','$city / $country'); UPDATE countries SET address_format_id = last_insert_id() WHERE countries_id = 222; DELETE FROM zones_to_geo_zones WHERE geo_zone_id =1; INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (32, 117, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (31, 105, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (30, 103, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (29, 98, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (28, 97, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (27, 84, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (25, 81, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (24, 73, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (23, 72, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (22, 67, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (21, 57, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (20, 56, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (19, 55, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (18, 21, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (17, 14, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (33, 123, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (34, 124, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (35, 132, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (36, 150, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (37, 160, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (38, 170, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (46, 171, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (47, 189, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (48, 190, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (49, 195, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (50, 203, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (51, 204, 0, 1, NULL, now()); INSERT INTO zones_to_geo_zones (association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES (52, 222, 0, 1, NULL, now()); UPDATE currencies SET title ='UK Pound', code='GBP' WHERE currencies_id = 1; UPDATE currencies SET symbol_left='£' WHERE currencies_id = 1;

hello, is there an oscommerce 2.3.4 bootstrap add-on for Quick UK Localisation feature yet? i can only find this add-on for earlier oscommerce version: http://addons.oscommerce.com/info/7845 Help to get a UK oscommerce 2.3.4 bootstrap store base set would be appreciated. Thanks!

hi FWRmedia, your help with this issue shown in my previous posts would be really appreciated when you can please. thank you!

hi FWR Media, sorry to ask again but still stuck with this issue. i just wondered if you are able to help with this? it would be really great if you could please. thank you in advance!

hi FWR, Yes agreed this is a great contribution, really clever how it works...congrats! The exact contents of the fields requested are: products_name = Axel products_model = CH A20 the description field is empty we actually display a field called "catalog_number" in the breadcrumb and on the product page, we do not display the "products_model" field. catalog_number field = CHA20 The breadcrumb we use works like this: Home / Main Cat / Sub Cat / Product Name [catalog number] so this products sits in the Furniture Main Cat and in the Chairs sub cat, with the product name "Axel" and Catalog Number "CHA20", displaying as: Home / Furniture / Chairs / Axel [CHA20] Any help to modify the code to avoid displaying details twice would be much appreciated. Thanks!

I'm sorry to bother you again FWRmedia, but i would really appreciate if you could help with this please: hi FWR Media, Great contribution! i have a question / problem i have noticed after i have installed this KissMT contribution (r76)...it is producing duplicate data in the Title, Meta Description and Meta Keywords, aswell as not displaying the catalog number correctly in 1 part of each of the Title, Description and Keywords. Example of what i mean showing the display output from the "product_info.php" aswell: i have a chair on my website called "Axel", the catalog number is "CH A20" and it is manufactured by Dane. i also have Breadcrumb with the following details (including the product name and catalog number in it), that is also displayed on this page for this product: Home / Furniture / Chairs / Axel [CH A20] It is generating this Title, Meta Name Description and Meta Name Keywords for the source on the product page: <title>Axel - CH A20 - Axel Cha20 - Chairs - Furniture - by Dane - Buy from House</title> <meta name="description" content="Axel, CH A20, Axel Cha20, Chairs, Furniture, by Dane."> <meta name="keywords" content="axel,a20,cha20,chairs,furniture,dane"> i guess it is the "kiss_meta_tags/modules/product_info.php" file code that needs to be modified to correctly display this without duplicating or error. i am using the original "kiss_meta_tags/modules/product_info.php" file that comes with you contribution. Any help explaining and showing what code to replace/delete to make the Title, Meta Description and Meta Keywords generate correctly for me would be really great. thanks!

hi FWR Media, Great contribution! i have a question / problem i have noticed after i have installed this KissMT contribution (r76)...it is producing duplicate data in the Title, Meta Description and Meta Keywords, aswell as not displaying the catalog number correctly in 1 part of each of the Title, Description and Keywords. Example of what i mean showing the display output from the "product_info.php" aswell: i have a chair on my website called "Axel", the catalog number is "CH A20" and it is manufactured by Dane. i also have Breadcrumb with the following details (including the product name and catalog number in it), that is also displayed on this page for this product: Home / Furniture / Chairs / Axel [CH A20] It is generating this Title, Meta Name Description and Meta Name Keywords for the source on the product page: <title>Axel - CH A20 - Axel Cha20 - Chairs - Furniture - by Dane - Buy from House</title> <meta name="description" content="Axel, CH A20, Axel Cha20, Chairs, Furniture, by Dane."> <meta name="keywords" content="axel,a20,cha20,chairs,furniture,dane"> i guess it is the "kiss_meta_tags/modules/product_info.php" file code that needs to be modified to correctly display this without duplicating or error. i am using the original "kiss_meta_tags/modules/product_info.php" file that comes with you contribution. Any help explaining and showing what code to replace/delete to make the Title, Meta Description and Meta Keywords generate correctly for me would be really great. thanks!

hi, i was wondering if someone might be able to answer and help with this question for me please: is it possible to have 2 "product_info.php" pages in the same website? that read from the same /admin/ area control panel. what i mean is for example: "product_info.php" - for all physical products "product_info_downloads.php" - for download/virtual products only. The reason i ask is because we would like for the downloads display to be DIFFERENT style layout and display compared to the display for physical products. The Physical products are displayed in the normal columns and rows. We would ideally like the download products to displayed in a grid list style display. Just wondered if it is possible for this to be done with Oscommerce website? We are using Oscommerce Online Merchant v2.2 RC2a / PHP Version 5.2.8 with STS template Any help or feedback on this question would be really really great and appreciated. thanks!

Please can anyone help with answering my question above?...it would be really great and appreciated if someone could. thank you!

hi, i have just installed Super Download Store into my Online Shop. i have a quick question which i hope people will be able to help and answer for me please: Do you have to use the "downloads.php?cpath=" file url method for download products? or can you use the "index.php?cpath=" method the same as you do for physical products?? i ask because at the moment my downloads.php' file page does not work for displaying products from the downloads category, but my index.php file does. Any help would be really great and appreciated. thanks!

hi, We are an Online Music Store. We have Suppliers/Distributors who send us their music download files and details in schema/XML file format. is there a module/add-on that can allow us to import this details straight into our store? without having to manually type all the products details out, as it is going from 100's to 1000's of products...as it is massively time consuming. or...if anyone knows of a script that can convert the XML file into a CSV file format?? or...if anyone is able to write a script for us that will allow our server/website to automatically integrate the xml/schema music file and product details deliveries data we receive via FTP into our website for us. Any help would be really very much appreciated, thanks!

hi, i am looking for a working Admin Demo of Oscommerce AJAX Attribute Manager. Does anyone know of a website link to a working demo of this Attribute Manager please? it would be really great if someone does...because i would very much like to see how this works and displays in the admin panel side of things, as it could solve a problem i have with regards to product_attributes. thanks!