poddan1
-
Posts
38 -
Joined
-
Last visited
Posts posted by poddan1
-
-
I dont agree.
Look at this
Totalt exkl shipping: 1.976kr
Shipping cost Fraktkostnad (Billigaste alternativ): 135
25 %Total vat incl : 422kr
Total sum : 2111
everything looks allright here ,even the vat for the shipping is included.
---------------
But if you change the shipping to 100 kr
The vat is wrong with 3 kr
look at this
Totalt exkl shipping: 1.976kr
Shipping cost Fraktkostnad (Billigaste alternativ): 100
25 %Total vat incl : 412kr
Total sum : 2076 2076 X 0,2 = 415,2 kr not 412 kr
--------------
Change the shipping to 0.00 kr
And it will calulate everything right again.
..
Can anyone else try this example ?
OK.. In sweden the tax is 25 % I had to change it to 25 % as you wrote
-
I have just installed order editor 1.61 and I can change the shipping costs ?! Removing is not possible but changing it seems no problem. When you need to adjust for free shipping put 0.00 instead of 0 (otherwise shipping is indeed calculated for zero but shown as the previous shipping cost). The other changes are reflected correctly although at first the calculation was wrong. Looking at the edit_order.php though showed there were some hard codes tax calculation on top which screwed up the calculation. After I just set them all to 0.0 everything was fine (for me tax is all included so I use no VAT but it might correct it for that also).
I dont agree.
Look at this
Totalt exkl shipping: 1.976kr
Shipping cost Fraktkostnad (Billigaste alternativ): 135
25 %Total vat incl : 422kr
Total sum : 2111
everything looks allright here ,even the vat for the shipping is included.
---------------
But if you change the shipping to 100 kr
The vat is wrong with 3 kr
look at this
Totalt exkl shipping: 1.976kr
Shipping cost Fraktkostnad (Billigaste alternativ): 100
25 %Total vat incl : 412kr
Total sum : 2076 2076 X 0,2 = 415,2 kr not 412 kr
--------------
Change the shipping to 0.00 kr
And it will calulate everything right again.
..
Can anyone else try this example ?
-
This module still needs the possibility to adjust or just remove the shipping cost in admin.
-
Here we can write down questions and new task that should improve order editor
-
#1062 - Duplicate entry '112' for key 1
You have allready insertet the sql file once..
go to datebase --> configuration_group ---> configuration_group_id klick onit
( show) look for
112 WYSIWYG Editor 1.7 HTMLArea 1.7 Options -----Delete it-----
Take the fixed sql file and run it again
-
Giles wrote this on page 6...did?nt you read?
Hi again,Well, I figured that out. In case it helps anyone, it's an empty column specification apparently, which SQL doesn't like. So you need to put a value after 'LARGE_IMAGE_WIDTH'. I put 'LARGE_IMAGE_WIDTH', '0', as '0' has been put for non-specific size, and you can always change it later in the admin.
Now, I have other problems - the information box is not displaying right and nor is the New Product page - it's all out of alignment, but I'm working on it.
-
'LARGE_IMAGE_WIDTH', , 'The
edit to 'LARGE_IMAGE_WIDTH', 0, 'The
And then do the higt too.
U can change this in admin later
-
did you fill in model nr in osc ?
-
delete entry in database
configuration_group_id take view and it looks like this
14 GZip Compression GZip compression options 14 1
15 Sessions Session options 15 1
113 WYSIWYG Editor 1.7 HTMLArea 1.7 Options 15
delete entry 112 ( i?ve change mine with 113 )
edit your sql file
Large Image Width (Pop-up)', 'LARGE_IMAGE_WIDTH', '0' , 'The pixel width of up)', 'LARGE_IMAGE_HEIGHT', '0' , 'The pixel
look at '0' the zero is missing in your sql... edit the two rows..
save and tri again
-
-
have som more wrongs..
1054 - Unknown column 'p.products_image_med' in 'field list'
select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_status = '1' and p.products_id = '1143' and pd.products_id = p.products_id and pd.language_id = '1'
It all have to do with ultra pics
-
I have the exact same fault..but i can not find anything in index.php at the catalog. please help
-
Ive tried to install this sql file
# NEW RECORDS FOR: WYSIWYG HTML AREA 1.7 and ULTRA IMAGES for MS2 # HTML_WYSIWYG_SQL.sql # Created by: MaxiDVD www.maxidvd.com.au INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('112', 'WYSIWYG Editor 1.7', 'HTMLArea 1.7 Options', '15', '1'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'PRODUCT DESCRIPTIONS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE', 'Enable', 'Enable/Disable WYSIWYG box', 112, 0, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Product Description Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_PD', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 10, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Product Description Layout Width', 'HTML_AREA_WYSIWYG_WIDTH', '505', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 15, now(), now(), NULL, ''); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Product Description Layout Height', 'HTML_AREA_WYSIWYG_HEIGHT', '240', 'How HIGH should the HTMLAREA be in pixels (default: 240)', 112, 19, now(), now(), NULL, ''); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'DEFINE MAINPAGE use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_DEFINE', 'Enable', 'Use WYSIWYG Area in Define Mainpage', 112, 25, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Define Mainpage Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_DEFINE', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 29, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Define Mainpage Layout Width', 'DEFINE_MAINPAGE_WYSIWYG_WIDTH', '605', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 35, now(), now(), NULL, ''); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Define Mainpage Layout Height', 'DEFINE_MAINPAGE_WYSIWYG_HEIGHT', '300', 'How HIGH should the HTMLAREA be in pixels (default: 140)', 112, 41, now(), now(), NULL, ''); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'INFORMATION PAGES UNLIMITED use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_IPU', 'Enable', 'Use WYSIWYG Area in Information Pages', 112, 44, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Information Pages Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_IPU', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 48, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Information Pages Layout Width', 'HTML_AREA_WYSIWYG_WIDTH_IPU', '505', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 51, now(), now(), NULL, ''); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Information Pages Layout Height', 'HTML_AREA_WYSIWYG_HEIGHT_IPU', '240', 'How HIGH should the HTMLAREA be in pixels (default: 240)', 112, 54, now(), now(), NULL, ''); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'CUSTOMER EMAILS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_EMAIL', 'Enable', 'Use WYSIWYG Area in Email Customers', 112, 59, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Customer Email Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_EMAIL', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 62, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Customer Email Layout Width', 'EMAIL_AREA_WYSIWYG_WIDTH', '550', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 66, now(), now(), NULL, ''); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Customer Email Layout Height', 'EMAIL_AREA_WYSIWYG_HEIGHT', '300', 'How HIGH should the HTMLAREA be in pixels (default: 140)', 112, 69, now(), now(), NULL, ''); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'NEWSLETTER EMAILS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_NEWSLETTER', 'Enable', 'Use WYSIWYG Area in Email Newsletter', 112, 72, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Newsletter Email Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_NEWSLETTER', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 75, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Newsletter Email Layout Width', 'NEWSLETTER_EMAIL_WYSIWYG_WIDTH', '505', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 77, now(), now(), NULL, ''); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Newsletter Email Layout Height', 'NEWSLETTER_EMAIL_WYSIWYG_HEIGHT', '140', 'How HIGH should the HTMLAREA be in pixels (default: 140)', 112, 79, now(), now(), NULL, ''); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'GLOBAL - User Interface (GUI) Font Type', 'HTML_AREA_WYSIWYG_FONT_TYPE', 'Times New Roman', 'User Interface Font Type<br>(not saved to product description)', 112, 82, now(), now(), NULL, 'tep_cfg_select_option(array(\'Arial\', \'Courier New\', \'Georgia\', \'Impact\', \'Tahoma\', \'Times New Roman\', \'Verdana\', \'Wingdings\'),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'GLOBAL - User Interface (GUI) Font Size', 'HTML_AREA_WYSIWYG_FONT_SIZE', '12', 'User Interface Font Size (not saved to product description)<p><b>10 Equals 10 pt', 112, 84, now(), now(), NULL, 'tep_cfg_select_option(array(\\\'8\\\', \\\'10\\\', \\\'12\\\', \\\'14\\\', \\\'18\\\', \\\'24\\\', \\\'36\\\'),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'GLOBAL - User Interface (GUI) Font Colour', 'HTML_AREA_WYSIWYG_FONT_COLOUR', 'Black', 'White, Black, C0C0C0, Red, FFFFFF, Yellow, Pink, Blue, Gray, 000000, ect..<br>basically any colour or HTML colour code!<br>(not saved to product description)', 112, 86, now(), now(), NULL, ''); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'GLOBAL - User Interface (GUI) Background Colour', 'HTML_AREA_WYSIWYG_BG_COLOUR', 'White', 'White, Black, C0C0C0, Red, FFFFFF, Yellow, Pink, Blue, Gray, 000000, ect..<br>basically any colour or html colour code!<br>(not saved to product description)', 112, 89, now(), now(), NULL, ''); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'GLOBAL - ALLOW DEBUG MODE?', 'HTML_AREA_WYSIWYG_DEBUG', '0', 'Moniter Live-html, It updates as you type in a 2nd field above it.<p>Disable Debug = 0<br>Enable Debug = 1<br>Default = 0 OFF', 112, 91, now(), now(), NULL, 'tep_cfg_select_option(array(\'0\', \'1\'),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Enable Additional Images?', 'ULTIMATE_ADDITIONAL_IMAGES', 'Enable', 'Display Additional Images below Product Description?', 4, 20, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Enable PHP Image Manager?', 'WYSIWYG_USE_PHP_IMAGE_MANAGER', 'Enable', 'Enable/Disable PHP Ultra-Image Manger?', 4, 21, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Additional Thumb Width', 'ULT_THUMB_IMAGE_WIDTH', '140', 'The pixel width of additional thumb images', 4, 23, now(), now(), NULL, NULL); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Additional Thumb Height', 'ULT_THUMB_IMAGE_HEIGHT', '120', 'The pixel height of additional thumb images', 4, 25, now(), now(), NULL, NULL); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Medium Image Width', 'MEDIUM_IMAGE_WIDTH', '200', 'The pixel width of medium images', 4, 28, now(), now(), NULL, NULL); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Medium Image Height', 'MEDIUM_IMAGE_HEIGHT', '200', 'The pixel height of medium images', 4, 30, now(), now(), NULL, NULL); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Large Image Width (Pop-up)', 'LARGE_IMAGE_WIDTH', , 'The pixel width of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 32, now(), now(), NULL, NULL); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Large Image Height (Pop-up)', 'LARGE_IMAGE_HEIGHT', , 'The pixel height of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 35, now(), now(), NULL, NULL); ALTER TABLE products ADD products_image_med VARCHAR(64) AFTER products_image; ALTER TABLE products ADD products_image_lrg VARCHAR(64) AFTER products_image_med; ALTER TABLE products ADD products_image_sm_1 VARCHAR(64) AFTER products_image_lrg; ALTER TABLE products ADD products_image_xl_1 VARCHAR(64) AFTER products_image_sm_1; ALTER TABLE products ADD products_image_sm_2 VARCHAR(64) AFTER products_image_xl_1; ALTER TABLE products ADD products_image_xl_2 VARCHAR(64) AFTER products_image_sm_2; ALTER TABLE products ADD products_image_sm_3 VARCHAR(64) AFTER products_image_xl_2; ALTER TABLE products ADD products_image_xl_3 VARCHAR(64) AFTER products_image_sm_3; ALTER TABLE products ADD products_image_sm_4 VARCHAR(64) AFTER products_image_xl_3; ALTER TABLE products ADD products_image_xl_4 VARCHAR(64) AFTER products_image_sm_4; ALTER TABLE products ADD products_image_sm_5 VARCHAR(64) AFTER products_image_xl_4; ALTER TABLE products ADD products_image_xl_5 VARCHAR(64) AFTER products_image_sm_5; ALTER TABLE products ADD products_image_sm_6 VARCHAR(64) AFTER products_image_xl_5; ALTER TABLE products ADD products_image_xl_6 VARCHAR(64) AFTER products_image_sm_6; # # Table structure `information` # DROP TABLE IF EXISTS information; CREATE TABLE information ( information_id tinyint(3) unsigned NOT NULL auto_increment, visible enum('1','0') NOT NULL default '1', v_order tinyint(3) unsigned NOT NULL default '0', info_title varchar(255) NOT NULL default '', description text NOT NULL, languages_id int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (information_id,languages_id) ) TYPE=MyISAM;
But phpmyadmin says
Fel
SQL-fr?ga :
INSERT INTO configuration_group( configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible )
VALUES (
'112', 'WYSIWYG Editor 1.7', 'HTMLArea 1.7 Options', '15', '1'
)
MySQL sa:
#1062 - Duplicate entry '112' for key 1
What do this mean?
-
check so you have whatever.gig or whatever.jpg in your image archive
-
Try downloading
Download Model/Price/Qty/Date tab-delimited .txt file to edit
ps I?ve have an updated version so you have model prise qty only
If you can download this then it probebly is the size of the file..
The script time takes to long..
You split when uploading?
Date in excel
Do you want to display seconds ?
look in excel formatting cells / time
-
First of all..
In easypopulate.php you have a standard field that tells you how long the modelnr should be maximum
//**** Size of products_model in products table **** // set this to the size of your model number field in the db. We check to make sure all models are no longer than this value. // this prevents the database from getting fubared. Just making this number bigger won't help your database! They must match! global $modelsize; $modelsize = 15;
modelnr should be a short number.. It?s for you so that u easy can order that the customer wants.
My nummers reflect the numbers that mine Manufacturers
have...
-
I?ve hade another sql wrong
Fel
SQL-fr?ga :
INSERT INTO configuration_group( configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible )
VALUES (
'112', 'WYSIWYG Editor 1.7', 'HTMLArea 1.7 Options', '15', '1'
)
MySQL sa:
#1062 - Duplicate entry '112' for key 1
-
I?ve got the same bad message..
But I do have more problems..
1 . Define MainPage
TEXT_FILE_DOES_NOT_EXIST
2. Warning: main(includes/languages/svenska/FILENAME_DEFINE_MAINPAGE): failed to open stream: No such file or directory in c:\inetpub\wwwroot\shop\index.php on line 307
Warning: main(): Failed opening 'includes/languages/svenska/FILENAME_DEFINE_MAINPAGE' for inclusion (include_path='.;c:\php\includes') in c:\inetpub\wwwroot\shop\index.php on line 307
Can any one help me please .. I?m a bit newbee here
New task for order editor
in General Add-Ons Support
Posted
Yes I think it work now.
And yes in sweden we have 25 % tax
We also have 6 % on books ect and I havent test it yet.
But I dont think it will work cause i?ve specified 25 in the file.