Add products by adding codes
Photo support
What kind of photos does the photographic support include? Can I receive photographs of models presenting Sentiell’s jewelry?
How to obtain products' photos after acquiring a company or purchasing goods from another Sentiell's client?
How can I use photos received as part of the photographic support? What rights and what limitations do I have?
What is the file format and resolution of pictures?
How can I download photos for processed order?
How to download photos for all purchased products?
* The list of purchased products includes goods purchased after 01.01.2019.
Can I download photos to my smartphone?
Can I outsource an additional photography editing or making a banner ad?
It is possible to use the banners prepared for our clients, available on our website www.sentiell.cz. Unfortunately, we do not make any additional graphics for our clients. However, you can use our sales banner and put one or more of them in your online store. The graphics are available here.
Can I receive the photos of models presenting Sentiell's jewelry?
Unfortunately, the photographs of the models presenting Sentiell's jewelry are excluded from the photographic support's offer. Check detailed conditions of photo support.
How can I download .csv file with an offer of purchased products?
Go to "Your account", in section "Photographic Support" choose [Download offer or photos]. Select feature "Mark all", and then click the button [Download offer in CSV file].
What kind of data does the .csv file contain?
|
|
Can I ask you to generate a custom-made file?
Unfortunately, no. Our application generates files in exactly the same way for every client. If you need less data, all you have to do is delete unnecessary columns. You can easily edit, add, delete, concatenate text columns, move columns or data to achieve the desired effect.
Does the .csv file contain current wholesale prices?
The file contains prices of products from your last order.
Why polish characters are not allowed in .csv file?
Polish characters will be displayed properly once you import the file encoded with the Unicode UTF-8. You can do that using Microsoft Excel or LibreOffice which we recommend because they provide easier and more automated ways to import UTF-8 files.
How to open UTF-8 encoded .csv file?
-
Open downloaded file from the list of recent downloads in your browser.
-
You can also open the file from the folder on your computer where the file was downloaded.
-
Once you open the file in LibreOffice, it will display a window "Text import". In section [Separator Options] select [Separated by], [Semicolon] and from the list of [Text delimiter] select quotation mark ["]. Open a dropdown menu [Character set].
-
Select [Unicode (UTF-8)] from [Character set] menu.
-
Click [OK] to confirm settings.
-
The .csv file will be opened as a new sheet in LibreOffice. All that's left to do is to adjust the column width and row height to fit the data.
How to concatenate text columns in .csv file?
-
In worksheet select the cell where you want to put the combined data (for example, let’s say you are choosing cell V2).
-
There are various ways you can combine contents of multiple cells into one cell in .csv file. In our example below, you will find useful information on how to use the ampersand symbol [ & ]. In formula bar type the following code then press [ENTER]:
=A2&" "&B2&" "&C2&" "&D2&" "&E2&" "&F2&" "&G2&" "&H2&" "&I2&" "&J2&" "&K2&" "&L2&" "&M2&" "&N2&" "&O2&" "&P2
* If you want to add spaces between data of the columns, you need to use a space enclosed in quotation marks [" "].
-
You will combine each column content separated by space into one selected cell.
-
You don't have to merge all columns. If you need only for example [Product ID], [Code], [Wholesale net price] and [Size name], use the following code:
=A2&" "&C2&" "&G2&" "&L2