- Posts: 157
- Thank you received: 18
[Réglé] Le bouton importer (Produits CSV)
13 years 7 months ago - 13 years 7 months ago #88776
by Bill D.
[Réglé] Le bouton importer (Produits CSV) was created by Bill D.
Bonjour,
La honte m'envahit mais je ne trouve pas la fonction importer pour les produits :blush:
J'arrive à exporter sans souci avec le bouton exporter.
Je modifie mes fichiers pour faire des tests d'import mais je ne vois pas de bouton "importer" à l'instar du bouton "exporter" dans hikashop> produits, vu notamment sur des screenshots mais impossible d'attraper cette interface.
Peux être faut il passer par le phpmyadmin ? Mais j'ai lu qu'il y'a une fonction d'import dans la partie gestion des produits.
Merci d'avance...
La honte m'envahit mais je ne trouve pas la fonction importer pour les produits :blush:
J'arrive à exporter sans souci avec le bouton exporter.
Je modifie mes fichiers pour faire des tests d'import mais je ne vois pas de bouton "importer" à l'instar du bouton "exporter" dans hikashop> produits, vu notamment sur des screenshots mais impossible d'attraper cette interface.
Peux être faut il passer par le phpmyadmin ? Mais j'ai lu qu'il y'a une fonction d'import dans la partie gestion des produits.
Merci d'avance...
Last edit: 13 years 7 months ago by Bill D..
Please Log in or Create an account to join the conversation.
13 years 7 months ago #88894
by nicolas
Replied by nicolas on topic Le bouton importer (Produits CSV)
Bonjour,
Dans votre menu HikaShop, Importer est un sous menu du menu Produits:
www.hikashop.com/media/doc/tuto_content_options_module_menu.png
C'est le menu juste en dessous du titre de la page.
Dans votre menu HikaShop, Importer est un sous menu du menu Produits:
www.hikashop.com/media/doc/tuto_content_options_module_menu.png
C'est le menu juste en dessous du titre de la page.
Please Log in or Create an account to join the conversation.
13 years 7 months ago - 13 years 7 months ago #88909
by Bill D.
Replied by Bill D. on topic Le bouton importer (Produits CSV)
Last edit: 13 years 7 months ago by Bill D..
Please Log in or Create an account to join the conversation.
13 years 7 months ago #88978
by Xavier
Replied by Xavier on topic Le bouton importer (Produits CSV)
Please Log in or Create an account to join the conversation.
13 years 7 months ago - 13 years 7 months ago #89037
by Bill D.
Replied by Bill D. on topic Le bouton importer (Produits CSV)
Ah ok...
Alors j'ai réessayé de réinstaller le com_ par dessus, mais comme ça ne fonctionne pas j'ai supprimer manuellement les com_hikashop, mod_hikashop et plg_hikashop.
Et installé la dernière version datée de ce jour. Même souci, le menu n'apparaît pas. Je ne suis pas sur que ce soit bien ré-installé, j'ai des titres "informatiques" style HIKA_WAITLIST ou VOTE_AND_COMMENT...
Je vous mets le rapport de débogage de joomla.
J'ai aussi activé le error reporting dans le php.ini mais je n'ai aucune idée où se trouve le résultat, je regarderai demain
Console de débogage Joomla!
Session
__default
session.counter ⇒ 34
session.timer.start ⇒ 1360262606
session.timer.last ⇒ 1360263789
session.timer.now ⇒ 1360263926
session.client.browser ⇒ Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:18.0) Gecko/20100101 Firefox/18.0
registry ⇒ {"application":{"lang":""},"com_installer":{"message":"","extension_message":"","redirect_url":null},"com_hikashop":{"product":{"limitstart":0,"filter_id":"17"}}}
user
session.token ⇒ fcc03734c1e630fbcf732cff90d2062f
Profil d'information
Occupation de la mémoire
10.53 MB (11,036,692 Bytes)
Requêtes de base de données
30 requêtes exécutées
SELECT `data`
FROM `gajz9_session`
WHERE `session_id` = '8u0vji4vusb4lkev04kdjumqi1'
SELECT extension_id AS id, element AS "option", params, enabled
FROM gajz9_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT folder AS type, element AS name, params
FROM gajz9_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3)
ORDER BY ordering
SELECT template, s.params
FROM gajz9_template_styles as s
LEFT JOIN gajz9_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
SELECT extension_id AS id, element AS "option", params, enabled
FROM gajz9_extensions
WHERE `type` = 'component'
AND `element` = 'com_hikashop'
SELECT *
FROM gajz9_hikashop_config
SELECT extension_id AS id, element AS "option", params, enabled
FROM gajz9_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT a.id
FROM gajz9_user_usergroup_map AS map
LEFT JOIN gajz9_usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 107
SELECT *
FROM gajz9_hikashop_widget
WHERE widget_published=1
AND (widget_access = 'all' OR widget_access LIKE '%,8,%')
ORDER BY widget_ordering ASC
SELECT b.*,a.*
FROM gajz9_hikashop_order AS a
LEFT JOIN gajz9_hikashop_user AS b
ON a.order_user_id=b.user_id
WHERE a.order_type='sale'
AND a.order_created > 1357671926
AND a.order_created < 1360263926
ORDER BY a.order_created DESC
LIMIT 7
SELECT category_id
FROM gajz9_hikashop_category
WHERE category_type='root'
LIMIT 1
SELECT category_id
FROM gajz9_hikashop_category
WHERE category_parent_id=1
AND category_type='status'
LIMIT 1
SELECT a.*
FROM gajz9_hikashop_category AS a
WHERE a.category_parent_id = 4
ORDER BY category_ordering ASC
LIMIT 0, 500
SHOW TABLES LIKE 'gajz9_falang_content'
SELECT lang_id as id, lang_code as code, image as shortcode, published as active
FROM gajz9_languages
WHERE published=1
SELECT *
FROM gajz9_falang_content AS b
WHERE b.reference_id IN (5,6,7,8,9)
AND b.reference_table='hikashop_category'
AND b.reference_field='category_name'
AND b.published=1
AND b.language_id=2
SELECT DATE_FORMAT(FROM_UNIXTIME(CAST(a.order_created AS SIGNED )+0),'%Y %j') AS calculated_date, SUM(a.order_full_price) AS total,a.order_currency_id AS currency_id
FROM gajz9_hikashop_order AS a
WHERE a.order_type='sale'
AND a.order_created > 1357671926
AND a.order_created < 1360263926
GROUP BY calculated_date, currency_id
ORDER BY calculated_date DESC
SELECT SUM(prod.order_product_price*prod.order_product_quantity) as Total, a.order_currency_id
FROM gajz9_hikashop_order AS a
LEFT JOIN gajz9_hikashop_order_product AS prod
ON a.order_id=prod.order_id
WHERE a.order_type='sale'
AND a.order_created > 1357671926
AND a.order_created < 1360263926
GROUP BY a.order_currency_id
SELECT *
FROM gajz9_hikashop_currency
WHERE currency_id IN (1)
SELECT *, SUM(prod.order_product_quantity) as Total, COUNT(a.order_id) AS quantity
FROM gajz9_hikashop_order_product AS prod
LEFT JOIN gajz9_hikashop_order AS a
on a.order_id=prod.order_id
WHERE a.order_created > 1328727926
AND a.order_created < 1360263926
AND a.order_status IN ('confirmed','shipped')
GROUP BY prod.order_product_name
ORDER BY Total DESC
LIMIT 1
SELECT u.name
FROM gajz9_hikashop_order AS o
LEFT JOIN gajz9_hikashop_user as hu
ON o.order_user_id=hu.user_id
LEFT JOIN gajz9_users as u
ON u.id=hu.user_cms_id
ORDER BY o.order_created ASC
LIMIT 1
SELECT COUNT(DISTINCT(a.order_id)) as Total, a.order_currency_id
FROM gajz9_hikashop_order AS a
LEFT JOIN gajz9_hikashop_order_product AS prod
ON a.order_id=prod.order_id
WHERE a.order_type='sale'
AND a.order_status IN ('created','confirmed')
AND a.order_created > 1360191600
AND a.order_created < 1360263926
GROUP BY a.order_currency_id
SELECT *, SUM(order_product_quantity) as Total
FROM gajz9_hikashop_order as a
LEFT JOIN gajz9_hikashop_order_product as prod
ON a.order_id=prod.order_id
LEFT JOIN gajz9_hikashop_product AS p
ON p.product_id=prod.product_id
LEFT JOIN gajz9_hikashop_product_category as cat
ON cat.product_id=p.product_id OR cat.product_id=p.product_parent_id
LEFT JOIN gajz9_hikashop_category as c
ON cat.category_id=c.category_id
WHERE a.order_created > 1359659126
AND a.order_created < 1360263926
GROUP BY c.category_id
ORDER BY Total DESC
LIMIT 1
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM gajz9_modules AS m
LEFT JOIN gajz9_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN gajz9_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 <= '2013-02-07 19:05:26')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-02-07 19:05:26')
AND m.access IN (1,1,2,3)
AND m.client_id = 1
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT COUNT(*)
FROM gajz9_messages
WHERE state = 0
AND user_id_to = 107
SELECT COUNT(session_id)
FROM gajz9_session
WHERE guest = 0
AND client_id = 1
SELECT COUNT(session_id)
FROM gajz9_session
WHERE guest = 0
AND client_id = 0
SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
FROM gajz9_menu_types AS a
LEFT JOIN gajz9_menu AS b
ON b.menutype = a.menutype
AND b.home != 0
LEFT JOIN gajz9_languages AS l
ON l.lang_code = language
WHERE (b.client_id = 0 OR b.client_id IS NULL)
GROUP BY a.id, a.menutype, a.description, a.title, b.menutype,b.language,l.image,l.sef,l.title_native
SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
FROM gajz9_menu AS m
LEFT JOIN gajz9_extensions AS e
ON m.component_id = e.extension_id
WHERE m.client_id = 1
AND e.enabled = 1
AND m.id > 1
ORDER BY m.lft
UPDATE `gajz9_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:34;s:19:\"session.timer.start\";i:1360262606;s:18:\"session.timer.last\";i:1360263789;s:17:\"session.timer.now\";i:1360263926;s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:18.0) Gecko/20100101 Firefox/18.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\"
:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\"
:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:12:\"redirect_url\";N;}s:12:\"com_hikashop\";O:8:\"stdClass\":1:{s:7:\"product\";O:8:\"stdClass\":2:{s:10:\"limitstart\";i:0;s:9:\"filter_id\";s:2:\"17\";}}}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"107\";s:4:\"name\";s:17:\"Super Utilisateur\";s:8:\"username\";s:7:\"william\";s:5:\"email\";s:26:\"contact@monsite.com\";s:8:\"password\";s:65:\"daf56d8902229b866748e4ce630e7c1c:LeWMX5h6uwB9aqRGddlvGFLaNER2ZRtS\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2012-12-06 15:35:52\";s:13:\"lastvisitDate\";s:19:\"2013-02-07 18:43:26\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"fcc03734c1e630fbcf732cff90d2062f\";}' , `time` = '1360263926'
WHERE `session_id` = '8u0vji4vusb4lkev04kdjumqi1'
26 types de requêtes exécutées, triées par occurrences.
Tables sélectionnées :
3 × SELECT extension_id AS id, element AS "option", params, enabled
FROM gajz9_extensions
2 × SELECT COUNT(session_id)
FROM gajz9_session
2 × SELECT category_id
FROM gajz9_hikashop_category
1 × SELECT COUNT(DISTINCT(a.order_id)) as Total, a.order_currency_id
FROM gajz9_hikashop_order AS a
LEFT JOIN gajz9_hikashop_order_product AS prod
ON a.order_id=prod.order_id
1 × SELECT u.name
FROM gajz9_hikashop_order AS o
LEFT JOIN gajz9_hikashop_user as hu
ON o.order_user_id=hu.user_id
LEFT JOIN gajz9_users as u
ON u.id=hu.user_cms_id
1 × SELECT *, SUM(prod.order_product_quantity) as Total, COUNT(a.order_id) AS quantity
FROM gajz9_hikashop_order_product AS prod
LEFT JOIN gajz9_hikashop_order AS a
on a.order_id=prod.order_id
1 × SELECT *
FROM gajz9_hikashop_currency
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM gajz9_modules AS m
LEFT JOIN gajz9_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN gajz9_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
FROM gajz9_menu AS m
LEFT JOIN gajz9_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
FROM gajz9_menu_types AS a
LEFT JOIN gajz9_menu AS b
ON b.menutype = a.menutype
AND b.home != 0
LEFT JOIN gajz9_languages AS l
ON l.lang_code = language
1 × SELECT COUNT(*)
FROM gajz9_messages
1 × SELECT SUM(prod.order_product_price*prod.order_product_quantity) as Total, a.order_currency_id
FROM gajz9_hikashop_order AS a
LEFT JOIN gajz9_hikashop_order_product AS prod
ON a.order_id=prod.order_id
1 × SELECT *, SUM(order_product_quantity) as Total
FROM gajz9_hikashop_order as a
LEFT JOIN gajz9_hikashop_order_product as prod
ON a.order_id=prod.order_id
LEFT JOIN gajz9_hikashop_product AS p
ON p.product_id=prod.product_id
LEFT JOIN gajz9_hikashop_product_category as cat
ON cat.product_id=p.product_id OR cat.product_id=p.product_parent_id
LEFT JOIN gajz9_hikashop_category as c
ON cat.category_id=c.category_id
1 × SELECT *
FROM gajz9_falang_content AS b
1 × SELECT a.id
FROM gajz9_user_usergroup_map AS map
LEFT JOIN gajz9_usergroups AS a
ON a.id = map.group_id
1 × SELECT *
FROM gajz9_hikashop_confi
1 × SELECT template, s.params
FROM gajz9_template_styles as s
LEFT JOIN gajz9_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 gajz9_extensions
1 × SELECT *
FROM gajz9_hikashop_widget
1 × SELECT b.*,a.*
FROM gajz9_hikashop_order AS a
LEFT JOIN gajz9_hikashop_user AS b
ON a.order_user_id=b.user_id
1 × SELECT `data`
FROM `gajz9_session`
1 × SELECT lang_id as id, lang_code as code, image as shortcode, published as active
FROM gajz9_languages
1 × SELECT a.*
FROM gajz9_hikashop_category AS a
1 × SELECT DATE_FORMAT(FROM_UNIXTIME(CAST(a.order_created AS SIGNED )+0),'%Y %j') AS calculated_date, SUM(a.order_full_price) AS total,a.order_currency_id AS currency_id
FROM gajz9_hikashop_order AS a
Autres tables :
1 × UPDATE `gajz9_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:34;s:19:\"session.timer.start\";i:1360262606;s:18:\"session.timer.last\";i:1360263789;s:17:\"session.timer.now\";i:1360263926;s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:18.0) Gecko/20100101 Firefox/18.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\"
:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\"
:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:12:\"redirect_url\";N;}s:12:\"com_hikashop\";O:8:\"stdClass\":1:{s:7:\"product\";O:8:\"stdClass\":2:{s:10:\"limitstart\";i:0;s:9:\"filter_id\";s:2:\"17\";}}}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"107\";s:4:\"name\";s:17:\"Super Utilisateur\";s:8:\"username\";s:7:\"william\";s:5:\"email\";s:26:\"contact@universmineral.com\";s:8:\"password\";s:65:\"daf56d8902229b866748e4ce630e7c1c:LeWMX5h6uwB9aqRGddlvGFLaNER2ZRtS\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2012-12-06 15:35:52\";s:13:\"lastvisitDate\";s:19:\"2013-02-07 18:43:26\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"fcc03734c1e630fbcf732cff90d2062f\";}' , `time` = '1360263926'
1 × SHOW TABLES LIKE 'gajz9_falang_content
Bon courage pour le décriptage ...
A bientôt
Alors j'ai réessayé de réinstaller le com_ par dessus, mais comme ça ne fonctionne pas j'ai supprimer manuellement les com_hikashop, mod_hikashop et plg_hikashop.
Et installé la dernière version datée de ce jour. Même souci, le menu n'apparaît pas. Je ne suis pas sur que ce soit bien ré-installé, j'ai des titres "informatiques" style HIKA_WAITLIST ou VOTE_AND_COMMENT...
Je vous mets le rapport de débogage de joomla.
J'ai aussi activé le error reporting dans le php.ini mais je n'ai aucune idée où se trouve le résultat, je regarderai demain

Console de débogage Joomla!
Session
__default
session.counter ⇒ 34
session.timer.start ⇒ 1360262606
session.timer.last ⇒ 1360263789
session.timer.now ⇒ 1360263926
session.client.browser ⇒ Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:18.0) Gecko/20100101 Firefox/18.0
registry ⇒ {"application":{"lang":""},"com_installer":{"message":"","extension_message":"","redirect_url":null},"com_hikashop":{"product":{"limitstart":0,"filter_id":"17"}}}
user
session.token ⇒ fcc03734c1e630fbcf732cff90d2062f
Profil d'information
Occupation de la mémoire
10.53 MB (11,036,692 Bytes)
Requêtes de base de données
30 requêtes exécutées
SELECT `data`
FROM `gajz9_session`
WHERE `session_id` = '8u0vji4vusb4lkev04kdjumqi1'
SELECT extension_id AS id, element AS "option", params, enabled
FROM gajz9_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT folder AS type, element AS name, params
FROM gajz9_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3)
ORDER BY ordering
SELECT template, s.params
FROM gajz9_template_styles as s
LEFT JOIN gajz9_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
SELECT extension_id AS id, element AS "option", params, enabled
FROM gajz9_extensions
WHERE `type` = 'component'
AND `element` = 'com_hikashop'
SELECT *
FROM gajz9_hikashop_config
SELECT extension_id AS id, element AS "option", params, enabled
FROM gajz9_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT a.id
FROM gajz9_user_usergroup_map AS map
LEFT JOIN gajz9_usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 107
SELECT *
FROM gajz9_hikashop_widget
WHERE widget_published=1
AND (widget_access = 'all' OR widget_access LIKE '%,8,%')
ORDER BY widget_ordering ASC
SELECT b.*,a.*
FROM gajz9_hikashop_order AS a
LEFT JOIN gajz9_hikashop_user AS b
ON a.order_user_id=b.user_id
WHERE a.order_type='sale'
AND a.order_created > 1357671926
AND a.order_created < 1360263926
ORDER BY a.order_created DESC
LIMIT 7
SELECT category_id
FROM gajz9_hikashop_category
WHERE category_type='root'
LIMIT 1
SELECT category_id
FROM gajz9_hikashop_category
WHERE category_parent_id=1
AND category_type='status'
LIMIT 1
SELECT a.*
FROM gajz9_hikashop_category AS a
WHERE a.category_parent_id = 4
ORDER BY category_ordering ASC
LIMIT 0, 500
SHOW TABLES LIKE 'gajz9_falang_content'
SELECT lang_id as id, lang_code as code, image as shortcode, published as active
FROM gajz9_languages
WHERE published=1
SELECT *
FROM gajz9_falang_content AS b
WHERE b.reference_id IN (5,6,7,8,9)
AND b.reference_table='hikashop_category'
AND b.reference_field='category_name'
AND b.published=1
AND b.language_id=2
SELECT DATE_FORMAT(FROM_UNIXTIME(CAST(a.order_created AS SIGNED )+0),'%Y %j') AS calculated_date, SUM(a.order_full_price) AS total,a.order_currency_id AS currency_id
FROM gajz9_hikashop_order AS a
WHERE a.order_type='sale'
AND a.order_created > 1357671926
AND a.order_created < 1360263926
GROUP BY calculated_date, currency_id
ORDER BY calculated_date DESC
SELECT SUM(prod.order_product_price*prod.order_product_quantity) as Total, a.order_currency_id
FROM gajz9_hikashop_order AS a
LEFT JOIN gajz9_hikashop_order_product AS prod
ON a.order_id=prod.order_id
WHERE a.order_type='sale'
AND a.order_created > 1357671926
AND a.order_created < 1360263926
GROUP BY a.order_currency_id
SELECT *
FROM gajz9_hikashop_currency
WHERE currency_id IN (1)
SELECT *, SUM(prod.order_product_quantity) as Total, COUNT(a.order_id) AS quantity
FROM gajz9_hikashop_order_product AS prod
LEFT JOIN gajz9_hikashop_order AS a
on a.order_id=prod.order_id
WHERE a.order_created > 1328727926
AND a.order_created < 1360263926
AND a.order_status IN ('confirmed','shipped')
GROUP BY prod.order_product_name
ORDER BY Total DESC
LIMIT 1
SELECT u.name
FROM gajz9_hikashop_order AS o
LEFT JOIN gajz9_hikashop_user as hu
ON o.order_user_id=hu.user_id
LEFT JOIN gajz9_users as u
ON u.id=hu.user_cms_id
ORDER BY o.order_created ASC
LIMIT 1
SELECT COUNT(DISTINCT(a.order_id)) as Total, a.order_currency_id
FROM gajz9_hikashop_order AS a
LEFT JOIN gajz9_hikashop_order_product AS prod
ON a.order_id=prod.order_id
WHERE a.order_type='sale'
AND a.order_status IN ('created','confirmed')
AND a.order_created > 1360191600
AND a.order_created < 1360263926
GROUP BY a.order_currency_id
SELECT *, SUM(order_product_quantity) as Total
FROM gajz9_hikashop_order as a
LEFT JOIN gajz9_hikashop_order_product as prod
ON a.order_id=prod.order_id
LEFT JOIN gajz9_hikashop_product AS p
ON p.product_id=prod.product_id
LEFT JOIN gajz9_hikashop_product_category as cat
ON cat.product_id=p.product_id OR cat.product_id=p.product_parent_id
LEFT JOIN gajz9_hikashop_category as c
ON cat.category_id=c.category_id
WHERE a.order_created > 1359659126
AND a.order_created < 1360263926
GROUP BY c.category_id
ORDER BY Total DESC
LIMIT 1
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM gajz9_modules AS m
LEFT JOIN gajz9_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN gajz9_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 <= '2013-02-07 19:05:26')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-02-07 19:05:26')
AND m.access IN (1,1,2,3)
AND m.client_id = 1
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT COUNT(*)
FROM gajz9_messages
WHERE state = 0
AND user_id_to = 107
SELECT COUNT(session_id)
FROM gajz9_session
WHERE guest = 0
AND client_id = 1
SELECT COUNT(session_id)
FROM gajz9_session
WHERE guest = 0
AND client_id = 0
SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
FROM gajz9_menu_types AS a
LEFT JOIN gajz9_menu AS b
ON b.menutype = a.menutype
AND b.home != 0
LEFT JOIN gajz9_languages AS l
ON l.lang_code = language
WHERE (b.client_id = 0 OR b.client_id IS NULL)
GROUP BY a.id, a.menutype, a.description, a.title, b.menutype,b.language,l.image,l.sef,l.title_native
SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
FROM gajz9_menu AS m
LEFT JOIN gajz9_extensions AS e
ON m.component_id = e.extension_id
WHERE m.client_id = 1
AND e.enabled = 1
AND m.id > 1
ORDER BY m.lft
UPDATE `gajz9_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:34;s:19:\"session.timer.start\";i:1360262606;s:18:\"session.timer.last\";i:1360263789;s:17:\"session.timer.now\";i:1360263926;s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:18.0) Gecko/20100101 Firefox/18.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\"
:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\"
:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:12:\"redirect_url\";N;}s:12:\"com_hikashop\";O:8:\"stdClass\":1:{s:7:\"product\";O:8:\"stdClass\":2:{s:10:\"limitstart\";i:0;s:9:\"filter_id\";s:2:\"17\";}}}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"107\";s:4:\"name\";s:17:\"Super Utilisateur\";s:8:\"username\";s:7:\"william\";s:5:\"email\";s:26:\"contact@monsite.com\";s:8:\"password\";s:65:\"daf56d8902229b866748e4ce630e7c1c:LeWMX5h6uwB9aqRGddlvGFLaNER2ZRtS\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2012-12-06 15:35:52\";s:13:\"lastvisitDate\";s:19:\"2013-02-07 18:43:26\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"fcc03734c1e630fbcf732cff90d2062f\";}' , `time` = '1360263926'WHERE `session_id` = '8u0vji4vusb4lkev04kdjumqi1'
26 types de requêtes exécutées, triées par occurrences.
Tables sélectionnées :
3 × SELECT extension_id AS id, element AS "option", params, enabled
FROM gajz9_extensions
2 × SELECT COUNT(session_id)
FROM gajz9_session
2 × SELECT category_id
FROM gajz9_hikashop_category
1 × SELECT COUNT(DISTINCT(a.order_id)) as Total, a.order_currency_id
FROM gajz9_hikashop_order AS a
LEFT JOIN gajz9_hikashop_order_product AS prod
ON a.order_id=prod.order_id
1 × SELECT u.name
FROM gajz9_hikashop_order AS o
LEFT JOIN gajz9_hikashop_user as hu
ON o.order_user_id=hu.user_id
LEFT JOIN gajz9_users as u
ON u.id=hu.user_cms_id
1 × SELECT *, SUM(prod.order_product_quantity) as Total, COUNT(a.order_id) AS quantity
FROM gajz9_hikashop_order_product AS prod
LEFT JOIN gajz9_hikashop_order AS a
on a.order_id=prod.order_id
1 × SELECT *
FROM gajz9_hikashop_currency
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM gajz9_modules AS m
LEFT JOIN gajz9_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN gajz9_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
FROM gajz9_menu AS m
LEFT JOIN gajz9_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
FROM gajz9_menu_types AS a
LEFT JOIN gajz9_menu AS b
ON b.menutype = a.menutype
AND b.home != 0
LEFT JOIN gajz9_languages AS l
ON l.lang_code = language
1 × SELECT COUNT(*)
FROM gajz9_messages
1 × SELECT SUM(prod.order_product_price*prod.order_product_quantity) as Total, a.order_currency_id
FROM gajz9_hikashop_order AS a
LEFT JOIN gajz9_hikashop_order_product AS prod
ON a.order_id=prod.order_id
1 × SELECT *, SUM(order_product_quantity) as Total
FROM gajz9_hikashop_order as a
LEFT JOIN gajz9_hikashop_order_product as prod
ON a.order_id=prod.order_id
LEFT JOIN gajz9_hikashop_product AS p
ON p.product_id=prod.product_id
LEFT JOIN gajz9_hikashop_product_category as cat
ON cat.product_id=p.product_id OR cat.product_id=p.product_parent_id
LEFT JOIN gajz9_hikashop_category as c
ON cat.category_id=c.category_id
1 × SELECT *
FROM gajz9_falang_content AS b
1 × SELECT a.id
FROM gajz9_user_usergroup_map AS map
LEFT JOIN gajz9_usergroups AS a
ON a.id = map.group_id
1 × SELECT *
FROM gajz9_hikashop_confi
1 × SELECT template, s.params
FROM gajz9_template_styles as s
LEFT JOIN gajz9_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 gajz9_extensions
1 × SELECT *
FROM gajz9_hikashop_widget
1 × SELECT b.*,a.*
FROM gajz9_hikashop_order AS a
LEFT JOIN gajz9_hikashop_user AS b
ON a.order_user_id=b.user_id
1 × SELECT `data`
FROM `gajz9_session`
1 × SELECT lang_id as id, lang_code as code, image as shortcode, published as active
FROM gajz9_languages
1 × SELECT a.*
FROM gajz9_hikashop_category AS a
1 × SELECT DATE_FORMAT(FROM_UNIXTIME(CAST(a.order_created AS SIGNED )+0),'%Y %j') AS calculated_date, SUM(a.order_full_price) AS total,a.order_currency_id AS currency_id
FROM gajz9_hikashop_order AS a
Autres tables :
1 × UPDATE `gajz9_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:34;s:19:\"session.timer.start\";i:1360262606;s:18:\"session.timer.last\";i:1360263789;s:17:\"session.timer.now\";i:1360263926;s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:18.0) Gecko/20100101 Firefox/18.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\"
:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\"
:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:12:\"redirect_url\";N;}s:12:\"com_hikashop\";O:8:\"stdClass\":1:{s:7:\"product\";O:8:\"stdClass\":2:{s:10:\"limitstart\";i:0;s:9:\"filter_id\";s:2:\"17\";}}}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"107\";s:4:\"name\";s:17:\"Super Utilisateur\";s:8:\"username\";s:7:\"william\";s:5:\"email\";s:26:\"contact@universmineral.com\";s:8:\"password\";s:65:\"daf56d8902229b866748e4ce630e7c1c:LeWMX5h6uwB9aqRGddlvGFLaNER2ZRtS\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2012-12-06 15:35:52\";s:13:\"lastvisitDate\";s:19:\"2013-02-07 18:43:26\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"fcc03734c1e630fbcf732cff90d2062f\";}' , `time` = '1360263926'1 × SHOW TABLES LIKE 'gajz9_falang_content
Bon courage pour le décriptage ...
A bientôt
Last edit: 13 years 7 months ago by Bill D..
Please Log in or Create an account to join the conversation.
13 years 7 months ago #89075
by Bill D.
Replied by Bill D. on topic Le bouton importer (Produits CSV)
Bonjour,
La nuit portant conseil j'avais souvenir d'une histoire avec un changement de position de menu qui pouvait engendrer différents bugs...
Alors j'ai fais composants> Hikashop> Configuration générale puis "onglet" Affichage et position du menu à "au dessus de l'aire proncipale".
Je me retrouve donc bien avec le menu contenant l'import dans la page produit, même s'il y a beaucoup de "slash" / et quelques décalages.
Je reviens vers vous si j'éprouve d'autres difficultés...
Merci.
La nuit portant conseil j'avais souvenir d'une histoire avec un changement de position de menu qui pouvait engendrer différents bugs...
Alors j'ai fais composants> Hikashop> Configuration générale puis "onglet" Affichage et position du menu à "au dessus de l'aire proncipale".
Je me retrouve donc bien avec le menu contenant l'import dans la page produit, même s'il y a beaucoup de "slash" / et quelques décalages.
Je reviens vers vous si j'éprouve d'autres difficultés...
Merci.
Please Log in or Create an account to join the conversation.
13 years 7 months ago - 13 years 7 months ago #89110
by Bill D.
Replied by Bill D. on topic Le bouton importer (Produits CSV)
Mais du coup en frontend j'ai des / partout dans les déclarations automatiques d'hikashop.
\45,00 € \ l\'unité\\
\s) produits en stock\
\Total\ \45,00 € \
EDIT : J'ai fais une réinstallation complète de joomla, en fait c'était un souci avec les magic quotes. Il fallait redémarrer le serveur.
J'ai garder la version hikashop d'avant celle du 7 février. Ca fonctionne.
\45,00 € \ l\'unité\\
\s) produits en stock\
\Total\ \45,00 € \
EDIT : J'ai fais une réinstallation complète de joomla, en fait c'était un souci avec les magic quotes. Il fallait redémarrer le serveur.
J'ai garder la version hikashop d'avant celle du 7 février. Ca fonctionne.
Last edit: 13 years 7 months ago by Bill D..
Please Log in or Create an account to join the conversation.
Time to create page: 0.221 seconds