Import log file

  • Posts: 40
  • Thank you received: 1
8 years 11 months ago #222759

-- HikaShop version -- : 2.6.0
-- Joomla version -- : 3.4.4
-- PHP version -- : 5.4.30
-- Browser(s) name and version -- : Chrome

Hi,

I have a strange situation in my shop: I made an import of more than thousand products.
yesterday a customer bought a product for 0,00 EUR because the product had only a price if he buys minimum number of 10. The system does not have a price starting from 0 or 1 piece of this article.
My import data has a price for 1 piece, of course.

Where Can I find a log what hikashop finally makes out of my import data. Is there any idea or possibility of verification or validation of data in my shop? Or validation of data which were imported?

by the way it seems that HS does not check if there is a price of 1 piece existing. it automatically offers for 0,00. Is this a bug or a feature? If a feature? how can I disable it?

Thanks,
Best regards,
Bernhard

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
8 years 11 months ago #222792

Hi,

1/ See : "Display 'add to cart' for free products"
www.hikashop.com/support/support/documen...ig.html#main_product
It will forbidden free products to be sold in your store.

2/ See "quantity per order"
www.hikashop.com/support/documentation/i...orm.html#restriction
There you can set the minimum quantity per order (10 in your case)

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 40
  • Thank you received: 1
8 years 11 months ago #222868

Hi Jerome,

Please read my description. Your reply does unfortunately neither fit to my questions, nor help to solve my problem with your system.

  1. we do not offer free products, so your "Display 'add to cart' for free products" configuration does not fit. the product has a price with a min. quantity of 10. HS does not treat this as a free product. We tested this. so this does neither fit, nor help
  2. I made a screenshot about the product in the backend and also in the frontend. if you have a look on thes screenshots, you will find out that our product has only 1 price with a min. quantity of 10. backend and frontend are consistent.
    BUT: The import procedure lost 2 prices: the price with min. quantity 1 and the price with min. quantity of 5. This is exactly the reason why I pushed this topic with the subject "import log file". I also appended the correponding import csv file. please search for "PRT.16.0013" and you will find 3 rows: 1 article with 3 prices (depending on the min. quantity).
  3. the minimum quantity per order attribute which your described in your reply, is a complete different thing. I am aware of this and this has not any impact to this topic.
  4. I passed another question to this topic which you seem to have ignored anyway: Please take care also for this question: "Can I find a log what hikashop finally makes out of my import data. Is there any idea or possibility of verification or validation of data in my shop? Or validation of data which were imported?"

I want to be very clear. We have serious problems with your shop because our product data are not presented correctly in the shop and our customers are starting to get angry. Same as me. We had already several issues and most of the questions need a lot of conversation in order that somebody really tries to understand our problem.
I provided (in the appendix) several screenshots and the import file. I expect that you (and your company) analyzes the error and tries to reproduce this situation. If I make a mistake in my import then I will correct this instantly, of course. If your system is buggy or the support team is not able to analyze/locate the problem or provide a solution for it, it may be a signal to us for choosing a different product.
I hope for your professional support,
thank you
Best regards,
Bernhard

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
8 years 11 months ago #223019

Hi,

The problem has nothing to do with a bug of HikaShop but to the way you wrote your CSV.
Like we usually recommend with the import, the best is to create one product configured the way you want it (with several prices) and then use the "export" button of the products listing in order to get a CSV which will give you an example of how it should be written.
As you'll see, you shouldn't have several rows for the product, but only one row, with the prices separated by a pipe (the | character) in the price_value column.
Then, the import will allow you to import several prices for your products.
If you put several rows for a product in a CSV, only the last one will be used so that why you got only one price in the product.

Last edit: 8 years 11 months ago by nicolas.

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

  • Posts: 40
  • Thank you received: 1
8 years 11 months ago #223049

Hi,

Thank you for your answer.
:unsure: Sometimes things appear a kind of sponkey. you write "...we usually recommend...", "...shouldn't have several rows...". It appears not to be a MUST. But if the system must have it in this way in order to work properly, it has to be a MUST - in kind of a specification.

You further write that only the last row will be used if I have several rows for a product in a CSV. In this case I identified a new featlure in your system: It works also if you have several rows per product. But it works only in approximately 95%. the remaining 5% are lost somehow and obviously randomly. A pattern cannot be recognized yet.

I will treat your recommendation as a kind of a MUST HAVE, so I will re-program the generation of the CSV files in the way you request ist, of course.
I will let you know about the results.

is there any way to get a log file from the import?

Thank you,
Regards,
Bernhard

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
8 years 11 months ago #223061

Hi,

It is a must. I wrote should in the spur of the moment. Please understand that English is not my mother tongue.

There is no log file generated. Turn on the debug mode of the Joomla configuration and you'll get all the MySQL queries that are run during the import in the bottom debug section of the result page. That's where we usually look to know if the import is working fine or not.

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

Time to create page: 0.063 seconds
Powered by Kunena Forum