adding new currency prices without using exchange

  • Posts: 27
  • Thank you received: 0
9 years 11 months ago #219129

-- HikaShop version -- : 2.6.0
-- Joomla version -- : 3.4.5
-- PHP version -- : 5.6
-- Browser(s) name and version -- : Chrome 46.0.2490.80 m
-- Error-message(debug-mod must be tuned on) -- : Joomla! Debug Console

Session
__default
__wf
hikashop_product_data
check_system_user ⇒ 10130
hikashop_variant_data
Profile Information
Time
Memory
Time: 0.0 ms / 0.0 ms Memory: 0.614 MB / 0.61 MB Application: afterLoad
Time: 93.6 ms / 93.6 ms Memory: 3.794 MB / 4.41 MB Application: afterInitialise
Time: 15.6 ms / 109.2 ms Memory: 0.364 MB / 4.77 MB Application: afterRoute
Time: 733.2 ms / 842.4 ms Memory: 10.373 MB / 15.15 MB Application: afterDispatch
Time: 0.0 ms / 842.4 ms Memory: 0.157 MB / 15.30 MB Application: beforeRenderModule mod_submenu (Admin Submenu)
Time: 0.0 ms / 842.4 ms Memory: 0.033 MB / 15.34 MB Application: afterRenderModule mod_submenu (Admin Submenu)
Time: 0.0 ms / 842.4 ms Memory: 0.022 MB / 15.36 MB Application: beforeRenderModule mod_status (User Status)
Time: 15.6 ms / 858.0 ms Memory: 0.035 MB / 15.39 MB Application: afterRenderModule mod_status (User Status)
Time: 0.0 ms / 858.0 ms Memory: 0.000 MB / 15.39 MB Application: beforeRenderModule mod_version (Joomla Version)
Time: 0.0 ms / 858.0 ms Memory: 0.009 MB / 15.40 MB Application: afterRenderModule mod_version (Joomla Version)
Time: 0.0 ms / 858.0 ms Memory: 0.000 MB / 15.40 MB Application: beforeRenderModule mod_toolbar (Toolbar)
Time: 31.2 ms / 889.2 ms Memory: 0.057 MB / 15.46 MB Application: afterRenderModule mod_toolbar (Toolbar)
Time: 0.0 ms / 889.2 ms Memory: 0.000 MB / 15.46 MB Application: beforeRenderModule mod_title (Title)
Time: 0.0 ms / 889.2 ms Memory: 0.004 MB / 15.46 MB Application: afterRenderModule mod_title (Title)
Time: 0.0 ms / 889.2 ms Memory: 0.001 MB / 15.46 MB Application: beforeRenderModule mod_menu (Admin Menu)
Time: 78.0 ms / 967.2 ms Memory: 0.178 MB / 15.64 MB Application: afterRenderModule mod_menu (Admin Menu)
Time: 0.0 ms / 967.2 ms Memory: 0.831 MB / 16.47 MB Application: afterRender

Database queries total: 280.8 ms
Memory Usage
16.49 MB (17,289,016 Bytes)
Database Queries
188 Queries Logged 280.8 ms

164 duplicate found!
16 duplicates: #9  #18  #24  #112  #118  #120  #121  #127  #129  #130  #136  #138  #139  #140  #145  #152
2 duplicates: #10  #19
2 duplicates: #12  #20
2 duplicates: #13  #21
2 duplicates: #14  #22
2 duplicates: #15  #23
2 duplicates: #17  #35
7 duplicates: #25  #113  #122  #131  #141  #146  #153
22 duplicates: #36  #39  #41  #43  #46  #49  #58  #77  #82  #86  #90  #95  #100  #110  #161  #163  #165  #167  #169  #170  #173  #176
12 duplicates: #37  #47  #50  #59  #78  #96  #101  #111  #162  #171  #174  #177
17 duplicates: #38  #40  #42  #44  #45  #48  #51  #81  #85  #89  #94  #99  #164  #166  #168  #172  #175
5 duplicates: #52  #70  #104  #154  #178
10 duplicates: #53  #55  #71  #73  #105  #107  #155  #157  #179  #181
10 duplicates: #54  #56  #72  #74  #106  #108  #156  #158  #180  #182
10 duplicates: #57  #75  #109  #116  #125  #134  #143  #150  #159  #183
15 duplicates: #60  #61  #62  #63  #64  #65  #66  #67  #68  #69  #114  #123  #132  #142  #147
2 duplicates: #76  #160
7 duplicates: #79  #83  #87  #91  #92  #97  #102
6 duplicates: #80  #84  #88  #93  #98  #103
3 duplicates: #115  #124  #133
6 duplicates: #117  #119  #126  #128  #135  #137
2 duplicates: #144  #151
2 duplicates: #148  #149
Query Time: 0.00 ms
SELECT `data`

  FROM `wl2_session`

  WHERE `session_id` = '3uuod8pmmldg0jdqufq8s91lg5'
Explain
Profile
Call Stack
Query Time: 0.00 ms
SELECT extension_id AS id, element AS "option", params, enabled

  FROM wl2_extensions

  WHERE `type` = 'component'
Explain
Profile
Call Stack
Query Time: 0.00 ms After last query: 15.60 ms
SELECT folder AS type, element AS name, params

  FROM wl2_extensions

  WHERE enabled = 1 
  AND type ='plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,2,3,6)

  ORDER BY ordering
Explain
Profile
Call Stack
Query Time: 15.60 ms After last query: 46.80 ms
SELECT extension_id AS id, element AS "option", params, enabled

  FROM wl2_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
Explain
Profile
Call Stack
Query Time: 0.00 ms
UPDATE `wl2_extensions`

  SET `params` = '{\"mediaversion\":\"4766f31fe20e6fed3e67a13f7ecd82bf\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
Explain
Profile
Call Stack
Query Time: 0.00 ms
SELECT template, s.params

  FROM wl2_template_styles as s

  LEFT JOIN wl2_extensions as e 
  ON e.type='template' 
  AND e.element=s.template 
  AND e.client_id=s.client_id

  WHERE s.client_id = 1 
  AND home = '1'

  ORDER BY home
Explain
Profile
Call Stack
Query Time: 0.00 ms After last query: 46.80 ms
SELECT * 
  FROM wl2_hikashop_config
Explain
Profile
Call Stack
Query Time: 0.00 ms After last query: 109.20 ms
SELECT * 
  FROM wl2_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.field_table='product'  
  ORDER BY a.`field_ordering` ASC
Explain
Profile
Call Stack
Query Time: 15.60 ms
Duplicate queries: #18  #24  #112  #118  #120  #121  #127  #129  #130  #136  #138  #139  #140  #145  #152
SHOW FULL COLUMNS 
  FROM `wl2_hikashop_product`
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #19
SELECT * 
  FROM wl2_hikashop_characteristic 
  ORDER BY characteristic_parent_id ASC, characteristic_ordering ASC
Explain
Profile
Call Stack
Query Time: 0.00 ms After last query: 15.60 ms
SELECT category_id 
  FROM wl2_hikashop_category 
  WHERE category_type='root' 
  LIMIT 1
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #20
SELECT category_id 
  FROM wl2_hikashop_category 
  WHERE category_parent_id=1 
  AND category_type='product' 
  LIMIT 1
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #21
SELECT category_id 
  FROM wl2_hikashop_category 
  WHERE category_parent_id=1 
  AND category_type='manufacturer' 
  LIMIT 1
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #22
SELECT category_id 
  FROM wl2_hikashop_category 
  WHERE category_parent_id=1 
  AND category_type='tax' 
  LIMIT 1
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #23
SELECT category_id 
  FROM wl2_hikashop_category 
  WHERE category_type='tax' && category_parent_id=3 
  ORDER BY category_ordering DESC
Explain
Profile
Call Stack
Query Time: 15.60 ms After last query: 15.60 ms
INSERT IGNORE INTO `wl2_hikashop_massaction` ( `massaction_id`,`massaction_name`,`massaction_description`,`massaction_published`,`massaction_table`,`massaction_triggers`,`massaction_filters`,`massaction_actions` ) 
  VALUES ( '0','','','1','product','','a:2:{i:1;O:8:\"stdClass\":2:{s:4:\"name\";s:9:\"csvImport\";s:4:\"data\";a:3:{s:4:\"type\";s:2:\"in\";s:8:\"pathType\";s:4:\"path\";s:4:\"path\";s:71:\"D:\\inetpub\\capsulz\\images\\com_hikashop\\upload\\test_antwerpen1_price.csv\";}}i:0;O:8:\"stdClass\":2:{s:4:\"name\";s:5:\"
  limit\";s:4:\"data\";a:2:{s:5:\"start\";s:1:\"0\";s:5:\"value\";s:3:\"500\";}}}','' )
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #35
SELECT * 
  FROM wl2_hikashop_massaction 
  WHERE massaction_id  = '4' 
  LIMIT 1
Explain
Profile
Call Stack
Query Time: 15.60 ms
Duplicate queries: #9  #24  #112  #118  #120  #121  #127  #129  #130  #136  #138  #139  #140  #145  #152
SHOW FULL COLUMNS 
  FROM `wl2_hikashop_product`
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #10
SELECT * 
  FROM wl2_hikashop_characteristic 
  ORDER BY characteristic_parent_id ASC, characteristic_ordering ASC
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #12
SELECT category_id 
  FROM wl2_hikashop_category 
  WHERE category_parent_id=1 
  AND category_type='product' 
  LIMIT 1
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #13
SELECT category_id 
  FROM wl2_hikashop_category 
  WHERE category_parent_id=1 
  AND category_type='manufacturer' 
  LIMIT 1
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #14
SELECT category_id 
  FROM wl2_hikashop_category 
  WHERE category_parent_id=1 
  AND category_type='tax' 
  LIMIT 1
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #15
SELECT category_id 
  FROM wl2_hikashop_category 
  WHERE category_type='tax' && category_parent_id=3 
  ORDER BY category_ordering DESC
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #9  #18  #112  #118  #120  #121  #127  #129  #130  #136  #138  #139  #140  #145  #152
SHOW FULL COLUMNS 
  FROM `wl2_hikashop_product`
Explain
Profile
Call Stack
Query Time: 15.60 ms
Duplicate queries: #113  #122  #131  #141  #146  #153
SHOW FULL COLUMNS 
  FROM `wl2_hikashop_price`
Explain
Profile
Call Stack
Query Time: 0.00 ms
SELECT * 
  FROM wl2_hikashop_product 
  WHERE product_code IN ('Antwerpen1')
Explain
Profile
Call Stack
Query Time: 0.00 ms
SELECT * 
  FROM wl2_hikashop_product_related AS a 
  WHERE a.product_id IN (1802) 
  ORDER BY a.product_related_ordering
Explain
Profile
Call Stack
Query Time: 0.00 ms
SELECT * 
  FROM wl2_hikashop_product 
  WHERE product_id IN (1802) OR product_parent_id IN (1802) 
  ORDER BY product_parent_id ASC, product_id ASC
Explain
Profile
Call Stack
Query Time: 0.00 ms
SELECT * 
  FROM wl2_hikashop_product_category 
  WHERE product_id IN (1802) 
  ORDER BY ordering ASC
Explain
Profile
Call Stack
Query Time: 0.00 ms
SELECT * 
  FROM wl2_hikashop_price 
  WHERE price_product_id IN (1802,1804,1805,1806,1807,1808,1809,1810,1811,1812,1813,1814,1815,1816,1817,1818,1819,1820,1821,1822,1823,1824,1825,1826,1827,1828,1829,1830,2203)
Explain
Profile
Call Stack
Query Time: 15.60 ms
SELECT * 
  FROM wl2_hikashop_file 
  WHERE file_ref_id IN (1802,1804,1805,1806,1807,1808,1809,1810,1811,1812,1813,1814,1815,1816,1817,1818,1819,1820,1821,1822,1823,1824,1825,1826,1827,1828,1829,1830,2203) 
  AND file_type IN ('product','file') 
  ORDER BY file_ordering ASC, file_id ASC
Explain
Profile
Call Stack
Query Time: 0.00 ms
SELECT * 
  FROM wl2_hikashop_variant 
  WHERE variant_product_id IN (1802,1804,1805,1806,1807,1808,1809,1810,1811,1812,1813,1814,1815,1816,1817,1818,1819,1820,1821,1822,1823,1824,1825,1826,1827,1828,1829,1830,2203) 
  ORDER BY ordering ASC
Explain
Profile
Call Stack
Query Time: 0.00 ms
SELECT * 
  FROM wl2_hikashop_product 
  WHERE product_code IN ('')
Explain
Profile
Call Stack
Query Time: 0.00 ms
SELECT currency_id 
  FROM wl2_hikashop_currency 
  WHERE currency_code LIKE 'RUB'
Explain
Profile
Call Stack
Query Time: 0.00 ms After last query: 15.60 ms
Duplicate queries: #17
SELECT * 
  FROM wl2_hikashop_massaction 
  WHERE massaction_id  = '4' 
  LIMIT 1
Explain
Profile
Call Stack
Query Time: 15.60 ms
Duplicate queries: #39  #41  #43  #46  #49  #58  #77  #82  #86  #90  #95  #100  #110  #161  #163  #165  #167  #169  #170  #173  #176
SHOW FULL COLUMNS 
  FROM `wl2_hikashop_user`
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #47  #50  #59  #78  #96  #101  #111  #162  #171  #174  #177
SHOW FULL COLUMNS 
  FROM `wl2_users`
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #40  #42  #44  #45  #48  #51  #81  #85  #89  #94  #99  #164  #166  #168  #172  #175
SHOW FULL COLUMNS 
  FROM `wl2_hikashop_address`
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #36  #41  #43  #46  #49  #58  #77  #82  #86  #90  #95  #100  #110  #161  #163  #165  #167  #169  #170  #173  #176
SHOW FULL COLUMNS 
  FROM `wl2_hikashop_user`
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #38  #42  #44  #45  #48  #51  #81  #85  #89  #94  #99  #164  #166  #168  #172  #175
SHOW FULL COLUMNS 
  FROM `wl2_hikashop_address`
Explain
Profile
Call Stack
Query Time: 15.60 ms
Duplicate queries: #36  #39  #43  #46  #49  #58  #77  #82  #86  #90  #95  #100  #110  #161  #163  #165  #167  #169  #170  #173  #176
SHOW FULL COLUMNS 
  FROM `wl2_hikashop_user`
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #38  #40  #44  #45  #48  #51  #81  #85  #89  #94  #99  #164  #166  #168  #172  #175
SHOW FULL COLUMNS 
  FROM `wl2_hikashop_address`
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #36  #39  #41  #46  #49  #58  #77  #82  #86  #90  #95  #100  #110  #161  #163  #165  #167  #169  #170  #173  #176
SHOW FULL COLUMNS 
  FROM `wl2_hikashop_user`
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #38  #40  #42  #45  #48  #51  #81  #85  #89  #94  #99  #164  #166  #168  #172  #175
SHOW FULL COLUMNS 
  FROM `wl2_hikashop_address`
Explain
Profile
Call Stack
Query Time: 0.00 ms After last query: 15.60 ms
Duplicate queries: #38  #40  #42  #44  #48  #51  #81  #85  #89  #94  #99  #164  #166  #168  #172  #175
SHOW FULL COLUMNS 
  FROM `wl2_hikashop_address`
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #36  #39  #41  #43  #49  #58  #77  #82  #86  #90  #95  #100  #110  #161  #163  #165  #167  #169  #170  #173  #176
SHOW FULL COLUMNS 
  FROM `wl2_hikashop_user`
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #37  #50  #59  #78  #96  #101  #111  #162  #171  #174  #177
SHOW FULL COLUMNS 
  FROM `wl2_users`
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #38  #40  #42  #44  #45  #51  #81  #85  #89  #94  #99  #164  #166  #168  #172  #175
SHOW FULL COLUMNS 
  FROM `wl2_hikashop_address`
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #36  #39  #41  #43  #46  #58  #77  #82  #86  #90  #95  #100  #110  #161  #163  #165  #167  #169  #170  #173  #176
SHOW FULL COLUMNS 
  FROM `wl2_hikashop_user`
Explain
Profile
Call Stack
Query Time: 15.60 ms
Duplicate queries: #37  #47  #59  #78  #96  #101  #111  #162  #171  #174  #177
SHOW FULL COLUMNS 
  FROM `wl2_users`
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #38  #40  #42  #44  #45  #48  #81  #85  #89  #94  #99  #164  #166  #168  #172  #175
SHOW FULL COLUMNS 
  FROM `wl2_hikashop_address`
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #70  #104  #154  #178
SELECT c.* 
  FROM wl2_hikashop_category AS c 
  WHERE c.category_type IN ('product','root','vendor','manufacturer') 
  AND c.category_depth >= 0 
  AND c.category_depth = 0 
  AND c.category_depth = 0 
  AND c.category_depth = 0 
  AND c.category_depth = 0 
  AND c.category_depth = 0 
  AND c.category_depth = 0 
  AND c.category_depth = 0 
  AND c.category_depth = 0 
  AND c.category_depth = 0 
  AND c.category_depth = 0 
  AND c.category_depth = 0 
  AND c.category_depth = 0 
  AND c.category_depth = 0 
  AND c.category_depth = 0 
  AND c.category_depth = 1 
  ORDER BY c.category_eft ASC, c.category_name ASC
Explain
Profile
Call Stack
Query Time: 0.00 ms After last query: 15.60 ms
Duplicate queries: #54  #56  #72  #74  #106  #108  #156  #158  #180
SELECT p.*, c.category_id 
  FROM wl2_hikashop_product AS p  
  INNER JOIN wl2_hikashop_product_category AS pc 
  ON p.product_id = pc.product_id 
  INNER JOIN wl2_hikashop_category AS c 
  ON c.category_id = pc.category_id 
  WHERE pc.category_id IN (0) 
  ORDER BY c.category_left ASC, c.category_name ASC, p.product_name ASC 
  LIMIT 0, 200
Explain
Profile
Call Stack
Query Time: 0.00 ms
Duplicate queries: #57  #75  #109  #116  #125  #134  #143  #150  #159
SELECT * 
  FROM wl2_hikashop_characteristic 
  WHERE characteristic_parent_id = 0
Explain
Profile
Call Stack
Query Time: 0.00 ms After last query: 15.60 ms
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM wl2_modules AS m

  LEFT JOIN wl2_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN wl2_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up = '2015-11-02 07:34:01') 
  AND m.access IN (1,1,2,3,6) 
  AND m.client_id = 1 
  AND (mm.menuid = 0 OR mm.menuid  1

  ORDER BY m.lft
Explain
Profile
Call Stack
38 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
12 × SELECT * 
  FROM wl2_hikashop_characteristic
10 × SELECT p.*, c.category_id 
  FROM wl2_hikashop_product AS p  
  INNER JOIN wl2_hikashop_product_category AS pc 
  ON p.product_id = pc.product_id 
  INNER JOIN wl2_hikashop_category AS c 
  ON c.category_id = pc.category_id
10 × SELECT c.*, 0 as `base_depth` 
  FROM wl2_hikashop_category AS c
9 × SELECT category_id 
  FROM wl2_hikashop_category
5 × SELECT c.* 
  FROM wl2_hikashop_category AS c
3 × SELECT * 
  FROM wl2_hikashop_product
2 × SELECT `category_name` 
  FROM wl2_hikashop_category
2 × SELECT extension_id AS id, element AS "option", params, enabled
 
  FROM wl2_extensions
2 × SELECT COUNT(session_id)
 
  FROM wl2_session
2 × SELECT * 
  FROM wl2_hikashop_product_relate
2 × SELECT * 
  FROM wl2_hikashop_massaction
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
 
  FROM wl2_modules AS m
 
  LEFT JOIN wl2_modules_menu AS mm 
  ON mm.moduleid = m.id
 
  LEFT JOIN wl2_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id
1 × SELECT currency_id 
  FROM wl2_hikashop_currency
1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
 
  FROM wl2_menu AS m
 
  LEFT JOIN wl2_extensions AS e 
  ON m.component_id = e.extension_id
1 × SELECT COUNT(*)
 
  FROM wl2_messages
1 × SELECT * 
  FROM wl2_hikashop_price
1 × SELECT * 
  FROM wl2_hikashop_confi
1 × SELECT template, s.params
 
  FROM wl2_template_styles as s
 
  LEFT JOIN wl2_extensions as e 
  ON e.type='template' 
  AND e.element=s.template 
  AND e.client_id=s.client_id
1 × SELECT folder AS type, element AS name, params
 
  FROM wl2_extensions
1 × SELECT * 
  FROM wl2_hikashop_field as a
1 × SELECT * 
  FROM wl2_hikashop_product_related AS a
1 × SELECT * 
  FROM wl2_hikashop_file
1 × SELECT `data`
 
  FROM `wl2_session`
1 × SELECT * 
  FROM wl2_hikashop_product_category
1 × SELECT * 
  FROM wl2_hikashop_variant
OTHER Tables:
22 × SHOW FULL COLUMNS 
  FROM `wl2_hikashop_user
17 × SHOW FULL COLUMNS 
  FROM `wl2_hikashop_address
16 × SHOW FULL COLUMNS 
  FROM `wl2_hikashop_product
15 × SHOW FULL COLUMNS 
  FROM `wl2_hikashop_category
12 × SHOW FULL COLUMNS 
  FROM `wl2_users
7 × SHOW FULL COLUMNS 
  FROM `wl2_hikashop_price
7 × SHOW FULL COLUMNS 
  FROM `wl2_hikashop_order
6 × SHOW FULL COLUMNS 
  FROM `wl2_hikashop_product_related
6 × SHOW FULL COLUMNS 
  FROM `wl2_hikashop_order_product
3 × SHOW FULL COLUMNS 
  FROM `wl2_hikashop_characteristic
2 × SHOW COLUMNS 
  FROM wl2_hikashop_fil
1 × UPDATE `wl2_extensions`
 
  SET `params` = '{\"mediaversion\":\"4766f31fe20e6fed3e67a13f7ecd82bf\"}'
1 × INSERT IGNORE INTO `wl2_hikashop_massaction` ( `massaction_id`,`massaction_name`,`massaction_description`,`massaction_published`,`massaction_table`,`massaction_triggers`,`massaction_filters`,`massaction_actions` ) 
  VALUES ( '0','','','1','product','','a:2:{i:1;O:8:\"stdClass\":2:{s:4:\"name\";s:9:\"csvImport\";s:4:\"data\";a:3:{s:4:\"type\";s:2:\"in\";s:8:\"pathType\";s:4:\"path\";s:4:\"path\";s:71:\"D:\\inetpub\\capsulz\\images\\com_hikashop\\upload\\test_antwerpen1_price.csv\";}}i:0;O:8:\"stdClass\":2:{s:4:\"name\";s:5:\"
  limit\";s:4:\"data\";a:2:{s:5:\"start\";s:1:\"0\";s:5:\"value\";s:3:\"500\";}}}',''
Hello All,

First, thanks a lot for this fantastic joomla component. I have tried a few shop extensions but this one is by far my favourite!

I'm having a problem with a multi-lingual / multi-currency website.
I have already set up 3 currencies on the website, with one main one and the currency switcher works fine. It calculates the prices in the other 2 currencies using the exchange rate I've set up. So nothing to worry here.

However, my aim, is to add prices to each product in the other two currencies. In that way, the exchange rate will be ignored, and when switching currencies, the entered value (not calculated by hikashop) will be displayed.

The reason for that is that I want to include half of the delivery fees within the price. And that's why I cannot use the exchange rate.

I followed a few threads on this forum and tried to achieve what I want through mass actions. However I get an error when trying to import the new currency to the existing product via csv files.
my csv look like this:
product_code,price_currency_id,price_value

So I already have USD prices assigned to each product and by this method I would like to add a EUR price.

The error I get is:
Notice: Undefined property: stdClass::$price_min_quantity in ...\plugins\hikashop\massaction_product\massaction_product.php on line 374

Notice: Undefined property: stdClass::$price_access in ...\plugins\hikashop\massaction_product\massaction_product.php on line 375

Could you please help?
Many thanks

Last edit: 9 years 11 months ago by Xavier. Reason: Adding [code] and [/code] tags

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
9 years 11 months ago #219134

Hi,

Please format your csv file this way:

product_code,price_currency_id,price_value,price_min_quantity,price_access
XX123,1,10,1,all

So just add the price_min_quantity and set it to "1", and price_access to "all" these are the default values.

We will see to improve the code to set these default values if missing.

Please Log in or Create an account to join the conversation.

  • Posts: 27
  • Thank you received: 0
9 years 11 months ago #219199

Hi Xavier,

Thanks for the quick reply, but it doesn't work, I have my default USD price that I've set while importing the products for the first time. With the mass action I'm trying to add the EUR price but no luck, it doesn't change anything.
However I got rid of the error message, so there is some progress :D

Cheers
Raphael

Please Log in or Create an account to join the conversation.

  • Posts: 27
  • Thank you received: 0
9 years 11 months ago #219200

I've just tried the "import" option instead of the mass action. And what it does is that it replaces the existing USD price by the EUR price, but does not keep the USD unfortunately...
If you would have a suggestion, I'd gladly take it :)

Please Log in or Create an account to join the conversation.

  • Posts: 27
  • Thank you received: 0
9 years 11 months ago #219209

sorry to post and repost but I've tried yet another two things:
I've set both prices (USD and EUR) manually into one of my products with a value of 1$ and 1€. Then I tried to update the EUR price through mass action with a csv file --> nothing happened
Then I tried the same csv file through the import option --> the EUR price got updated but USD price disappeared

Am I doing something wrong ?
mass action returns:
"Message
Successfully Saved
onProcessProductMassFiltercsvImport called"

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
9 years 11 months ago #219244

Hi,

I think that you have to add many prices at one time, like that:

product_code,price_currency_id,price_value,price_min_quantity,price_access
XX123,1|2,10|11,1|1,all|all

Thanks to the pipes, you can add as many prices as you want at one time, keep in mind that these prices will replace the existing ones.

Last edit: 9 years 11 months ago by Xavier.

Please Log in or Create an account to join the conversation.

  • Posts: 27
  • Thank you received: 0
9 years 11 months ago #219299

It indeed worked :)))))
but only through product import

Thanks a lot!
Raphael

Please Log in or Create an account to join the conversation.

Time to create page: 0.085 seconds
Powered by Kunena Forum