Multiple expressions in one expression ;-)
Hello guys,
U dont belive how much Im glad I found this forum exist.
I have {0,50}} format as price format in csv so I'm removing { and }} with this expression:
REPLACE (REPLACE([CSV_COL(2)], '{' , ''), '}}' , '')
Result is of course 0,50.
Now I need to construct a expression which:
if the value is equal to or less than "x" will multiply this cell "x2"
if the value is greater than "x" it will multiply this cell "x1.50"
how to manage that problem?
Much thanks,
Rafal Thanks for your post....
remove the CRLF character
hi, I need to remove the CRLF character from the description field, you have a suggestion thanks
best regards Hello Perrone Vincenzo,
The CRLF linebreak can be removed, only if it is formatted with the HTML tag <br>.
In this case, you may apply the following expression to the imported field
REPLACE ([CSV_COL(5)], '<br>', '')
Where 5 is a number of the column in the CSV file.
Unfortunately it is not a TAG, using ASCII code is not possible?
thanks
best regards Hello Perrone Vi...
FEED EXPORT CUSTOM PRODUCTS
Hello,
I need to create a product feed, which has the title of the column on 2 lines, and of the category column "the ID" of the main category only and not of the complete path.
Can you give me an idea?
Best Regards Hello Perrone Vincenzo,
Yes, it is possible to export the default category ID only following these steps:
1. Disable "Export full category path" in the Advanced Export options of Import/Export Wizard.
2. Enable "Use ID as a category path"
3. Add the following expression field to...
SET THE QUANTITY TO 0 WHEN IT IS NOT PRESENT IN THE CSV FILE
Hello,
in the new version there is no longer the possibility to set to 0 the articles that are not present in the csv file. Hello Perrone Vincenzo,
The option is present in the latest version of Store Manager for PrestaShop.
Please provide us with the screenshot, where the option is missing. Hello Perrone Vincenzo,
We've just reproduced the issue with the missing options and our techs are checking it. Hello Perrone Vincenzo,
The Import Wizard has been extended with the additional ident...
EAN ERROR
When I import the csv files, the EAN code is shorter than 13 characters, when this happens it is because the zeroes (0) are missing at the beginning of the code.
There is a possibility to correct
Thanks
Hello Perrone Vincenzo,
Store Manager does not truncate the zeroes from the cells and imports data as it is.
Most likely the file has been opened in MS Excel or any other spreadsheet editor before import, which truncated the zeroes. yes, I know, it's not a store manager to cut 0, it's alrea...
CATEGORY ASSIGN ERROR
Hello to all,
after the latest version of Storemanager, I found that when uploading products from csv files, the uploaded categories are not set as default categories.
Yours sincerely.
this is example when i import product
CASE
WHEN [CSV_COL(3)] = 'ABBIGLIAMENTO,Abbigliamento Donna,Accessori Uomo Donna' THEN 'Root|Home page|Abbigliamento|Abbigliamento Donna|Accessori Uomo Donna'
WHEN [CSV_COL(3)] = 'ABBIGLIAMENTO,Abbigliamento Donna,Intimo Biologico' THEN 'Root|Home page|Abbigliamento|Abbiglia...