Sku Grid

13. Open Sku Grid in another tab and go to your marketplace settings.  Settings --> Marketplaces --> Shopify (Country) Note: If you haven't already created it, you'll need to click Connect a Marketplace and then select it.

Enter your Shopify URL. This will be your myshopify link found in your browser of your Shopify Dashboard and not your masked domain link. The format will typically be https://name.myshopify.com 

Copy and paste your Shopify Keys that you had saved into a notepad or other secure location into your Sku Grid settings.

Step 1: The first step is to log to Sku Grid and you'll be on the My Items page. Click Add Single Item

Step 2: Your Reference Id is a free text field. It is just used to help you easily identify your items on the grid. You can enter what you want here.

Step 3: Type in what you would like for your Reference ID. Some people use a few keywords, an item number, etc. It is up to you.

Step 4: Next, is the Supplier's Item Link. This is your supplier url to the individual product you're listing.

Step 5: Right Click and Paste in your Supplier's Item Link 

Step 6: Some suppliers such as Amazon and Walmart have certain pricing options. They should not be left at default. Click default and make the selection for the pricing option you want.

Step 7: In this example, we'll Select Lowest Prime Seller.

Step 8: Next, is the Supplier's Variation Name. If your supplier has a variation and does not have a unique URL for the variation, you'll need to enter the variation name. If there is more than one attribute, you'll separate them with a vertical line.

Step 9: Enter your Supplier's Variation Name if applicable, otherwise, leave this blank if there is none.

Step 10: Maximum Days Before Dispatch at Supplier - This is how many days you want to allow the supplier to take to ship the item out before Sku Grid considers the item out of stock. The default in your General Settings is 7 days (unless you’ve changed it).

Step 11: Continued...When adding items to the grid, it’s defaulted to Use Global. If you want a different option per item set it here. If it can be estimated that the supplier will take longer than this many days to ship, Sku Grid would treat the item as OOS.

Step 12: Select Use Global to use the time frame set in your General Settings otherwise, make a different selection here.

Step 13: Next, you'll need to select your Selling Marketplace. Click Do Not Update My Item.

Step 14: Select Shopify USA (US) or the Shopify Country Marketplace that you are selling on.

Step 15: Your Marketplace Item Number is your shopify product number.  You will need to log into your Shopify Dashboard and obtain the product number from within Shopify.

Step 16: To get the Product Number, Click Products in your Shopify Dashboard.

Step 17: Click the Product That You're Adding to Sku Grid. Once you're on the product editor page, there will be a number at the end of the URL in your browser.  That is the product number. Copy that number.

Step 18: Right Click and Paste in your Shopify Item/Product Number into the Marketplace Item Number Field.

Step 19: If you're listing a multi-variation Shopify listing, then you'll need to go to the front end of your product page, locate the product and at the end of the URL will be ?variant= The number that is after variant is the Variation ID.

Step 20: If your item has a variation on Shopify, then copy and paste in that Click Variant ID here. Otherwise, leave it blank if it is not a variation item.

Step 21: Pause Repricing This means do you want to stop all updates to price and stock for your Shopify Listing. This does not stop supplier url checking.

Step 22: Select No if you want Sku Grid to be able to update your price and/or stock on Shopify.

Step 23: Default Quantity - If you want this particular item to have a different default quantity than what you have set in your marketplace settings, you would select a different number here.

Step 24: Select None if you are okay with using the Default Quantity from your Marketplace Settings, or select a different quantity for this item.

Step 25: If you want to have a different pricing structure or formula for this item, you can override your selling price formula. You would need to click Override Default Selling Formula. This is optional.

Step 26: If overriding the item, then you would use the Wizard and Estimate Price to create and test your formula. Otherwise, if not overriding, your item will take on the formula from your marketplace settings.

Step 27: Click Add Item

Step 28: Your item has been successfully added to Sku Grid for tracking and repricing. 

Step 29: Please note that if the supplier url has not been scraped yet, it will show as "Vendor" until Sku Grid has had a chance to check it the first time around.

Step 30: That's it. You've added your first Shopify item to Sku Grid! Happy Selling!

Step 1: Log into Sku Grid and Click Import/Export

Step 2: Click Import From Marketplace

Step 3: Note: Imported items will all be imported in a Paused state. This is to allow you time to put in the correct supplier url, variation, adjust your formula, etc, before unpausing and releasing the item for tracking/updating.

Step 4: Click Import Your Items from Shopify (US or whichever country you're selling on).

Step 5: Note: There are 2 importing options. The first is to import items that already exist in sku grid to sync the data. The other is to Import New Products that don't exist within your Sku Grid account. Click Import New Products that Do Not Exist in SG.

Step 6: You'll see an alert indicating how many items were imported successfully.

Step 7: You should then Click the 2nd Filter on the Page.

Step 8: Select SHOPIFY US (or whichver country you're selling on).

Step 9: Notice that imported items show with the Reference ID as "shopify_us_import" followed by the item number and variation id.

Step 10: The supplier url may be blank until you edit the entry and put in the supplier urls and it may show up as Vendor if we have never scraped the item yet, until Sku Grid has had a chance to scrape it.

Step 11: Notice that all imported items are Paused. This is to allow you time to edit them, input the supplier url & variation (if applicable), and set Pause Repricing to No.

Step 12: If there is a variation on your Shopify Listing, you'll see it here as part of the Marketplace Item information.

Step 13: Click Edit

Step 14: Right Click and paste in your Supplier Item Link

Step 15: Click vendor_variant

Step 16: Select No to turn Pause Repricing OFF.

Step 17: Default Quantity - If you want a different default quantity for this individual item than what is in your marketplace settings, you can make a selection, otherwise leave it at None.

Step 18: If you need to create a custom formula for this item, then  you can Override the Default Selling Price Formula, use the Wizard, and Estimate the price info

Step 19: Click Update Item

Step 20: The item may show the supplier url as "Vendor" until Sku Grid has had a chance to check the item the first time around.

Step 21: That's it. You've now imported your items from the Shopify Marketplace and we've showed you how to update the supplier url and unpause the item(s).

Step 1: The first step is to open a Google Drive Spreadsheet and click File

Step 2: With your mouse, hover over New

Step 3: Click Spreadsheet

Step 4: Rename Your spreadsheet and give it a title.

Step 5: Click in the first cell. You will use the first row of your spreadsheet for your column headers. At a minimum, you will need to enter the following column headers. The column headers have to be done exactly as shown and in lowercase letters.

Step 6: Type reference. This will be your reference ID.

Step 7: Type vendor_url. This will be your supplier url.

Step 8: Type vendor_variant. This will be your supplier variation (if applicable).

Step 9: Type reprice_store. This will be the marketplace and country that you are selling on.

Step 10: Type reprice_sku. This will be your item number.

Step 11: Type reprice_variant This will be your variation of your listing (if applicable).

Step 12: In the reference column type in your reference ID. Press Tab to move to the vendor_url column and paste Right Click and paste in your supplier url. 

Step 13: Be sure to add your pricing option if listing from a store such as Amazon or Walmart that has one. Otherwise, the items would be set to Default.

Step 14: If your supplier has a variation, then you'll want to copy your supplier variation.

Step 15: Double-click in the vendor_variant column.

Step 16: Paste in your supplier variation. If more than one attribute is needed, separate them with a vertical line (Shift + \) Example: Iris/Gingham|M M.  If you have no supplier variation, then leave this field blank.

Step 17: Type in your reprice_store. The reprice_store that you enter must be in all CAPITAL LETTERS. It will be SHOPIFY_US or whichever country you're listing on.

Step 18: From your Shopify Dashboard, Click Products

Step 19: Click on the product that you're adding to Sku Grid. Once it opens up in a new tab, copy the number at the end of the URL in your browser. That will be your Shopify Item Number or reprice_sku.

Step 20: Paste in your Shopify Item Number in the reprice_sku column.

Step 21: The reprice_variant is your Shopify Variation if applicable. If you are not adding a variation item, then leave blank. Otherwise, you'll need to find your variant ID.

Step 22: To get your variation id, Click View on your product in Shopify. This will open up the front end of the product in a new tab.

Step 23: Click on your variation attribute options. In this example, click Aruba Blue/Gingham

Step 24: Select Iris/Gingham as that is the color that we are tracking.

Step 25: Click S M to select a size attribute.

Step 26: Select M M as that is the size that we are tracking. You'll notice that each time you make a selection, there is a number at the end of the URL in your browser after ?variant= . That is your Variant ID. Copy that number.

Step 27: Paste in your Variant ID (if applicable) into the reprice_variant column. If there is no variation, then leave blank.

Step 28: Continue to add your items to the CSV file.

Step 29: Once you're finished, Click File

Step 30: Click Comma-separated values (.csv, current sheet) This will download the CSV file in the proper format to your computer. If you also use Excel, don't open it as it will mess up your item and variation ID numbers.

Step 31: Go back to your Sku Grid account and Click Import/Export

Step 32: Click Import CSV

Step 33: Click Choose CSV File. You will browse for the CSV file on your computer and then click Open.

Step 34: You will see an alert that tells you that your items were imported.

Step 35: You'll be able to see your items in the grid.

Step 36: Your supplier url may show up as "vendor" for a while until Sku Grid does it's first check of the item. You'll notice also, if you entered a supplier variation, that the variation name will be present.

Step 37: You'll see a link to your Shopify Marketplace Item in the Marketplace Item Column. 

Step 38: If your item is a multi-variation item on Shopify and you've added the variation, you'll see that information present under Variation ID.

Step 39: Please note, that if your items are Paused, you will need to edit the entry and set Pause Repricing to No before Sku Grid is able to make revisions to that item.

Step 40: That's it. You've successfully imported a CSV of your Shopify items into Sku Grid account.