<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>thread Re: Can I upload UPC codes directly from Register? in Hardware Setup &amp; Troubleshooting</title>
    <link>https://community.squareup.com/t5/Hardware-Setup-Troubleshooting/Can-I-upload-UPC-codes-directly-from-Register/m-p/707172#M1144</link>
    <description>&lt;P&gt;&lt;a href="https://community.squareup.com/t5/user/viewprofilepage/user-id/149832"&gt;@Violet&lt;/a&gt;&amp;nbsp;;&lt;/P&gt;&lt;P&gt;You should be able to upload the UPC scan right from the register.&amp;nbsp; If it works like my Square Stand.&lt;/P&gt;&lt;P&gt;Different ways to do this:&lt;/P&gt;&lt;P&gt;&amp;nbsp; &amp;nbsp;1 )&amp;nbsp; From Checkout Screen san the item that is not in your system.&amp;nbsp; A pop up will appear asking if you want to add this SKU or GTIN since it does not appear in your Square Catalog.&amp;nbsp; &amp;nbsp;Wording may be different but you get the idea.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp; &amp;nbsp; 2) Bottom right press More &amp;gt; Items then you can Select Create Item and scan the Barcode into the SKU or GTIN field.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp; &amp;nbsp; 3) If you already have items without a SKU field assign or GTIN assigned you can search for the Item and add the Barcode scan to the coresponding field.&amp;nbsp; Just remember that the GTIN field has specific rules that need to be followed, if not square gives a warning not a leagal GTIN value.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Question 2)&lt;/P&gt;&lt;P&gt;Yes you can either make up your own SKU (Stock Keeping Unit) value up to 30 characters in length of numbers and letters.&amp;nbsp;&amp;nbsp;&lt;/P&gt;&lt;P&gt;If you want to random numbers and letters you can use Google Sheets or Excel and the Unique and Random features combined.&lt;/P&gt;&lt;P&gt;Here is a Video on how to generate random numbers in Google Sheets.&amp;nbsp; &amp;nbsp;So if you have say 1000 items coming in with No SKU on them you can use for example&amp;nbsp; &amp;nbsp;Type this in a Google cell&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;=randbetween(1000000,9999999)&lt;/P&gt;&lt;P&gt;this is actually saying generate a Random number between 1000000 and 9999999 for a 7 digit SKU you can adjust this to make higher skus too.&amp;nbsp; Or you can adjust it to have SKUs for T-shirts between 1001000 and 1002000 to keep your catagories ending or starting with a certain sequence.&lt;/P&gt;&lt;P&gt;This will give you 1 Random number between 1000000 and 9999999..... so a 9 digit random SKU all numbers&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Now if you want Random numbers for the 1000 items you have coming in you would enter this in a google cell:&lt;/P&gt;&lt;P&gt;=randarray(1000)&amp;nbsp;&amp;nbsp;&lt;/P&gt;&lt;P&gt;this will give you 1000 rows of unique numbers&amp;nbsp; &amp;nbsp;catch is if you use this multiple times you may get matching SKU's&lt;/P&gt;&lt;P&gt;Then in a cell next to that row, you can put this in and copy it down the row&amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;SPAN class=""&gt;=&lt;/SPAN&gt;&lt;SPAN class=""&gt;round&lt;/SPAN&gt;&lt;SPAN class=""&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;B1&lt;/SPAN&gt;&lt;SPAN class=""&gt;*&lt;/SPAN&gt;&lt;SPAN class=""&gt;1000000000&lt;/SPAN&gt;&lt;SPAN class=""&gt;,&lt;/SPAN&gt;&lt;SPAN class=""&gt;0&lt;/SPAN&gt;&lt;SPAN class=""&gt;)&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN class=""&gt;This will then round the decimal places to a whole number with 9 digits .... only issue is if it generates .0000567656 you would get a sku of&amp;nbsp; 567656 for example.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN class=""&gt;The other alternative since a SKU can have a mix of numbers and letters is create a simple SKU for your items.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN class=""&gt;Like for me since a SKU can be upto 30 charachters long.... but then the barcode is also VERY long which is why most barcodes are 7 to 14 digits characters long.&amp;nbsp; Squares SKU Generator I have found makes them a mix of letters and numbers between 7 and 8 characters in length.&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN class=""&gt;I went with 8 Black Cherry&amp;nbsp; &amp;nbsp; for my 8oz Black cherry candle&amp;nbsp; or 64 Black cherry for my half gallon Black Cherry candles..... my single line Barcodes would not fit a label tho and I started using 2D barcodes similar to a QR code.&amp;nbsp; now to get this simplified to between 7 and 14 characters&amp;nbsp; I could do the 8 Black Cherry which is 14 characters and 64 Black Cherr for my SKU&amp;nbsp; &amp;nbsp;I could also make it 8blkcher&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN class=""&gt;and 64blkche to keep them at 8 characters.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN class=""&gt;There are also YouTube videos for some easy ways to create your own SKU using codes you create.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;here is one for example :&amp;nbsp;&lt;A href="https://youtu.be/1UvIoXJjpHU?si=u-MmnS07IJvaVawV" target="_blank" rel="noopener"&gt;Create SKUs for your Small Business&lt;/A&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I do not know if you can use the - or / etc to be a sepperator between Size Color Style etc.&amp;nbsp; I recommend staying with just Numbers and Letters.&amp;nbsp; &amp;nbsp;Another reason to use your own code is if your barcode gets damaged it is easier to type in a Barcode you created rather than some random number to find the item.&amp;nbsp; Since I use BF for my back flow cones and then the Scent, if a barcode is damaged I type in BFDrago...... and the list of items I have with a sku or item name starting that way starts showing up before I fully type in "BFDragonsBlood", for example. This is easier for me to remember that items SKU over 7657HG58 for example from a Square Generated one or other program you can get for Google Sheets or Excel to create your SKU's.&amp;nbsp;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 31 Jan 2024 17:48:55 GMT</pubDate>
    <dc:creator>Candlestore</dc:creator>
    <dc:date>2024-01-31T17:48:55Z</dc:date>
    <item>
      <title>Can I upload UPC codes directly from Register?</title>
      <link>https://community.squareup.com/t5/Hardware-Setup-Troubleshooting/Can-I-upload-UPC-codes-directly-from-Register/m-p/707123#M1143</link>
      <description>&lt;P&gt;After about 5 years and growth we are finally adding a scanner to facilitate faster checkout. The support articles I’ve seen say to upload these to dashboard, but can I upload them directly from Register in the Items section?&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;Question 2: for items such as bulk items that do not have a upc code, is&amp;nbsp;&lt;SPAN&gt;there a way to generate these for free without enrolling in Square for Retail or similar subscription? &amp;nbsp;I&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;don't need the codes to be recognized outside my store so they don’t have to be truly unique.&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Sun, 21 Sep 2025 07:43:36 GMT</pubDate>
      <guid>https://community.squareup.com/t5/Hardware-Setup-Troubleshooting/Can-I-upload-UPC-codes-directly-from-Register/m-p/707123#M1143</guid>
      <dc:creator>Violet</dc:creator>
      <dc:date>2025-09-21T07:43:36Z</dc:date>
    </item>
    <item>
      <title>Re: Can I upload UPC codes directly from Register?</title>
      <link>https://community.squareup.com/t5/Hardware-Setup-Troubleshooting/Can-I-upload-UPC-codes-directly-from-Register/m-p/707172#M1144</link>
      <description>&lt;P&gt;&lt;a href="https://community.squareup.com/t5/user/viewprofilepage/user-id/149832"&gt;@Violet&lt;/a&gt;&amp;nbsp;;&lt;/P&gt;&lt;P&gt;You should be able to upload the UPC scan right from the register.&amp;nbsp; If it works like my Square Stand.&lt;/P&gt;&lt;P&gt;Different ways to do this:&lt;/P&gt;&lt;P&gt;&amp;nbsp; &amp;nbsp;1 )&amp;nbsp; From Checkout Screen san the item that is not in your system.&amp;nbsp; A pop up will appear asking if you want to add this SKU or GTIN since it does not appear in your Square Catalog.&amp;nbsp; &amp;nbsp;Wording may be different but you get the idea.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp; &amp;nbsp; 2) Bottom right press More &amp;gt; Items then you can Select Create Item and scan the Barcode into the SKU or GTIN field.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp; &amp;nbsp; 3) If you already have items without a SKU field assign or GTIN assigned you can search for the Item and add the Barcode scan to the coresponding field.&amp;nbsp; Just remember that the GTIN field has specific rules that need to be followed, if not square gives a warning not a leagal GTIN value.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Question 2)&lt;/P&gt;&lt;P&gt;Yes you can either make up your own SKU (Stock Keeping Unit) value up to 30 characters in length of numbers and letters.&amp;nbsp;&amp;nbsp;&lt;/P&gt;&lt;P&gt;If you want to random numbers and letters you can use Google Sheets or Excel and the Unique and Random features combined.&lt;/P&gt;&lt;P&gt;Here is a Video on how to generate random numbers in Google Sheets.&amp;nbsp; &amp;nbsp;So if you have say 1000 items coming in with No SKU on them you can use for example&amp;nbsp; &amp;nbsp;Type this in a Google cell&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;=randbetween(1000000,9999999)&lt;/P&gt;&lt;P&gt;this is actually saying generate a Random number between 1000000 and 9999999 for a 7 digit SKU you can adjust this to make higher skus too.&amp;nbsp; Or you can adjust it to have SKUs for T-shirts between 1001000 and 1002000 to keep your catagories ending or starting with a certain sequence.&lt;/P&gt;&lt;P&gt;This will give you 1 Random number between 1000000 and 9999999..... so a 9 digit random SKU all numbers&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Now if you want Random numbers for the 1000 items you have coming in you would enter this in a google cell:&lt;/P&gt;&lt;P&gt;=randarray(1000)&amp;nbsp;&amp;nbsp;&lt;/P&gt;&lt;P&gt;this will give you 1000 rows of unique numbers&amp;nbsp; &amp;nbsp;catch is if you use this multiple times you may get matching SKU's&lt;/P&gt;&lt;P&gt;Then in a cell next to that row, you can put this in and copy it down the row&amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;SPAN class=""&gt;=&lt;/SPAN&gt;&lt;SPAN class=""&gt;round&lt;/SPAN&gt;&lt;SPAN class=""&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;B1&lt;/SPAN&gt;&lt;SPAN class=""&gt;*&lt;/SPAN&gt;&lt;SPAN class=""&gt;1000000000&lt;/SPAN&gt;&lt;SPAN class=""&gt;,&lt;/SPAN&gt;&lt;SPAN class=""&gt;0&lt;/SPAN&gt;&lt;SPAN class=""&gt;)&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN class=""&gt;This will then round the decimal places to a whole number with 9 digits .... only issue is if it generates .0000567656 you would get a sku of&amp;nbsp; 567656 for example.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN class=""&gt;The other alternative since a SKU can have a mix of numbers and letters is create a simple SKU for your items.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN class=""&gt;Like for me since a SKU can be upto 30 charachters long.... but then the barcode is also VERY long which is why most barcodes are 7 to 14 digits characters long.&amp;nbsp; Squares SKU Generator I have found makes them a mix of letters and numbers between 7 and 8 characters in length.&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN class=""&gt;I went with 8 Black Cherry&amp;nbsp; &amp;nbsp; for my 8oz Black cherry candle&amp;nbsp; or 64 Black cherry for my half gallon Black Cherry candles..... my single line Barcodes would not fit a label tho and I started using 2D barcodes similar to a QR code.&amp;nbsp; now to get this simplified to between 7 and 14 characters&amp;nbsp; I could do the 8 Black Cherry which is 14 characters and 64 Black Cherr for my SKU&amp;nbsp; &amp;nbsp;I could also make it 8blkcher&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN class=""&gt;and 64blkche to keep them at 8 characters.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN class=""&gt;There are also YouTube videos for some easy ways to create your own SKU using codes you create.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;here is one for example :&amp;nbsp;&lt;A href="https://youtu.be/1UvIoXJjpHU?si=u-MmnS07IJvaVawV" target="_blank" rel="noopener"&gt;Create SKUs for your Small Business&lt;/A&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I do not know if you can use the - or / etc to be a sepperator between Size Color Style etc.&amp;nbsp; I recommend staying with just Numbers and Letters.&amp;nbsp; &amp;nbsp;Another reason to use your own code is if your barcode gets damaged it is easier to type in a Barcode you created rather than some random number to find the item.&amp;nbsp; Since I use BF for my back flow cones and then the Scent, if a barcode is damaged I type in BFDrago...... and the list of items I have with a sku or item name starting that way starts showing up before I fully type in "BFDragonsBlood", for example. This is easier for me to remember that items SKU over 7657HG58 for example from a Square Generated one or other program you can get for Google Sheets or Excel to create your SKU's.&amp;nbsp;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 31 Jan 2024 17:48:55 GMT</pubDate>
      <guid>https://community.squareup.com/t5/Hardware-Setup-Troubleshooting/Can-I-upload-UPC-codes-directly-from-Register/m-p/707172#M1144</guid>
      <dc:creator>Candlestore</dc:creator>
      <dc:date>2024-01-31T17:48:55Z</dc:date>
    </item>
  </channel>
</rss>

