To reach the service, you must connect on your account Mein Konto, "My store", "Upload a csv/txt file". Each step matches the pages on your screen during the upload of your catalogue.STEP 1Select the file to upload under format TXT or CSV & preferably zipped.
(If it is Excel, first
export the file to TXT)
Specify if it is an update or only additions to your catalogue.
[!] WARNINGIf you select the complete update, your existing catalogue you will be
ENTIRELY erased and replaced by the new one!
STEP 2The system displays the features which have been detected in your file(number of line, file delimiter, number of column).
2 options for you :
- you have already done an upload before and wish to re-use all parameters you had previously set up; in that case, click on
UPDATE DIRECTLY => you are done!
- you wish to change some parameters
OR
- this is your 1st upload >>> In these cases, click on
UPDATE STEP BY STEP[!] WARNINGIf the system detects a modification of delimiter file or number of columns, you will be required to do your update step by step to check if the parameters are already matching with your file.
STEP 3Match your columns (C1, C2, C3…) with the fields of the cdandlp's database. The required fields are marked with a star. If you do not have the matching column, leave the selection empty. Some fields (artist, title, description…) can contain several columns of your file (example: You wish to insert the media into the description because of its specificities).
An extract of your file is available at the bottom of the page, and your fields are renamed C1, C2, C3 ...
Do the corresponding between your columns (use the extract of your file available at the bottom of your page) and cdandlp’s.
click on
NEXTSTEP 4Do the corresponding between your columns (use the extract of your file available at the bottom of your page) and cdandlp’s. The categories in red are not mapped with ours (use the scrolling list to define a category).
click on
NEXTSTEP 5Match your file's medias with cdandlp's standards.
[!] WARNINGAll items whose media will not be specified will be
OUT of your cdandlp catalogue (they will appear in the error report at the end of your upload).
click on
NEXTSTEP 6Specify your items' condition (record and cover):- If there is no column for their condition because the items can ALL be defined as new:
=>Select "
All New"
- If you wish to give your items ALL a same used condition (cover/record)
=> Select "
Used" (and give a more precise condition that will be applied to the your entire catalogue!)
- If your file contains the condition for record and cover, have them match those used by cdandlp.
[!] WARNINGThis is a very important information for your future customers and you have to be very rigorous about it.
click on
NEXTSTEP 7About your selling price:
- To apply a discount or raise your prices up (in percentage) on your selling price:
Enter: – or + followed by the percentage in numbers
(Example for 20% off = write :
-20)
If prices do not change, just enter : 0
If you want to add an amount on each items :
- Enter an amount in the same currency as the one in your file.
At the end choose the currency used in your file.
click on
NEXTTREATMENT OF YOUR FILEEnd of step 2 or 7, the displayed message will confirm that your request was recorded.
The update of your catalogue will be carried out within 4 hours. For this period, you cannot start again a new update.
Once done, an update summary containing the possible detected errors will be sent to you by email.
HOW TO AUTOMATE UPDATE OF YOUR CATALOGUE ?For an automated upload of your catalogue, you must follow the instructions from this
link.
Next, send an email to upload@cdandlp.com indicating the solution that you have chosen, with the needed information to set the automatique upload.
Needed information :
- Name of your file (FTP Mode)
- URL enabling to pick up your file (URL Mode)
- Update frequency (once, twice, ... or seven times per week)
