- Posts: 27
- Thank you received: 0
adding new currency prices without using exchange
10 years 10 months ago - 10 years 10 months ago #219129
by skot
adding new currency prices without using exchange was created by skot
-- 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
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
-- 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
Code:
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\";}}}',''
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: 10 years 10 months ago by Xavier. Reason: Adding [code] and [/code] tags
Please Log in or Create an account to join the conversation.
10 years 10 months ago #219134
by Xavier
Replied by Xavier on topic adding new currency prices without using exchange
Hi,
Please format your csv file this way:
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 format your csv file this way:
Code:
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.
10 years 10 months ago #219199
by skot
Replied by skot on topic adding new currency prices without using exchange
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
Cheers
Raphael
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
Cheers
Raphael
Please Log in or Create an account to join the conversation.
10 years 10 months ago #219200
by skot
Replied by skot on topic adding new currency prices without using exchange
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
If you would have a suggestion, I'd gladly take it
Please Log in or Create an account to join the conversation.
10 years 10 months ago #219209
by skot
Replied by skot on topic adding new currency prices without using exchange
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"
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.
10 years 10 months ago - 10 years 10 months ago #219244
by Xavier
Replied by Xavier on topic adding new currency prices without using exchange
Hi,
I think that you have to add many prices at one time, like that:
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.
I think that you have to add many prices at one time, like that:
Code:
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: 10 years 10 months ago by Xavier.
Please Log in or Create an account to join the conversation.
10 years 10 months ago #219299
by skot
Replied by skot on topic adding new currency prices without using exchange
It indeed worked ))))
but only through product import
Thanks a lot!
Raphael
))))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.205 seconds