Announcement

Collapse
No announcement yet.

Discogs Quicklister (Uploading Sales Inventory with CSV file)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Discogs Quicklister (Uploading Sales Inventory with CSV file)

    So Ive started to do some spring crate cleaning and getting an outpile together. Thought Id throw them on Discogs and saw that you can bulk upload your sales inventory. I would say that Im ok with basic IT software like Office and such, so I thought this would be an easy exercise. Following the instructions on how to format the CSV file with the appropriate headers, I tried and tried again but I always got an error message.

    Does anyone use this regularly and could help out?

    The way I set it up is in row 1,column 1 I write the headers in this way:

    release_id,price,media_condition,sleeve_condition, comments

    In the Following cell below I enter one record each in the same fashion. So what am I doing wrong?
    Hip-Hop: https://soundcloud.com/beater-pan

    Everything else: https://mixcloud.com/beater-pan

    Instagram: http://instagram.com/beater_pan

  • #2
    Never done it this way but I would try listing five the conventional way and then downloading them fro Discogs as a CSV file.

    Then try tweaking this and uploading again.

    If it works just build that file.
    Spirit Duplicator—collectable, charming, affordable... and also socially networked on FB / Twitter / Instagram.

    Comment


    • #3
      what's the error message?

      Comment


      • #4
        While we are all at it. Is it easier to mass reduce prices that way? Reduce one column by 2 or something like that? I vaguely remember ding that in Excel.
        All the Wolpertingers

        Comment


        • #5
          The columns of your CSV are wrong.
          See this page for a description of the correct CSV format:

          https://support.discogs.com/en/suppo...e-quicklister-
          Dave Lee Roth, I Too Am Running With This Devil Of Which You Speak (sic)

          Comment


          • #6
            Didn't know you could do that ... nice!
            "White paper inner sleeve is pristine ..."

            Comment


            • #7
              So, Im still not getting it I guess..

              Tried the export file method after adding some inventory, then added on to that and uploading it. Didnt work..

              As to wrong columns, is it the formatting? Do the headers need to be in bold?

              Might also boil down to me using Numbers on my mac (Apple's pendant to Excel) and maybe something going wrong there..
              Hip-Hop: https://soundcloud.com/beater-pan

              Everything else: https://mixcloud.com/beater-pan

              Instagram: http://instagram.com/beater_pan

              Comment


              • #8
                Do you have the option to save it as older version of excel file with Numbers?
                'I have avoided competitive situations because I am not a baboon'

                Comment


                • #9
                  Ah, you're using a mac, this explains everything!!

                  You'll have to abandon discogs and switch to Apple's iDiscogs,
                  agreeing to potential human centipede scenarios in the process, as memorably exposed on South Park.

                  Seriously, you're probably making a tiny error somewhere. It's incredibly fruistrating that this kind of interface doesn't give more detailed error messages and leaves you guessing as to what exactly you're doing wrong, AKA Welcome to the future, where software is no longer tested.

                  Yes you must include the column headers, yes the names must match EXACTLY as shown on that link I posted (but they do not need to be in bold) and most important character encoding must be UTF-8. So when you save the file, using Save As, you must select UTF-8 instead of ANSI (or whatever satanic effluent Apple favour in their unholy wares).
                  Last edited by Milesago; 01-03-2017, 11:06 AM. Reason: spellings corrected
                  Dave Lee Roth, I Too Am Running With This Devil Of Which You Speak (sic)

                  Comment


                  • #10
                    You could upload your Numbers file to Google Spreadsheets and then download it as an Excel file. I think.
                    Spirit Duplicator—collectable, charming, affordable... and also socially networked on FB / Twitter / Instagram.

                    Comment


                    • #11
                      Another option is to download Open Office for mac (it's free) , read your current CSV file into the spreadsheet tool, and then write it out again with UTF-8 encoding. And swear never to buy Apple products again.
                      Dave Lee Roth, I Too Am Running With This Devil Of Which You Speak (sic)

                      Comment


                      • #12
                        Amen!
                        All the Wolpertingers

                        Comment

                        Working...
                        X