Sku Grid is proud to announce that we offer full support for Shopify stores. You're now able to use all of our over 600+ supplier sources to dropship from on your Shopify Sites.  This guide will walk you through setup.


1. Create Your Shopify App



Step 1: The first step is to open your Shopify Site Dashboard and click Apps

Step 2: Click Manage private apps

Step 3: Click Create a new private app

Step 4: Give your app a name. You can type anything you want in the Private app name field. In this example, we will just call it "Test Shopify Repricer".

Step 5: Enter your email address in the Contact email field.

Step 6: Click Review Disabled Admin API Permissions. This will expand permissions that are normally collapsed/hidden.

Step 7: Set Orders, Transactions & Fulfillments to Read Access.

Step 8: Set Products, Variants and Collections to Read and write

Step 9: Set Shipping rates, countries and provinces to Read and write.

Step 10: Set Product information to  Read and write.

Step 11: Set Locations to Read access.

Step 12: Set Inventory to Read and write.

Step 13: Click Save

Step 14: You will see a pop up that says Create a new private app. Click I understand, create the app.

Step 15: You will see an alert stating that the app was created successfully. Your API details will be below.

Here's an interactive tutorial for the visual learners

https://www.iorad.com/player/144642/Sku-Grid-Shopify-Repricer--Create-Your-Shopify-App



2. Connect Your Shopify Store to Sku Grid



Step 1: Once you are logged into Sku Grid, click on Settings.

Step 2: Click Marketplaces

Step 3: Click Shopify

Step 4: Click US or the Country You're Selling On.

Step 5: You will see an error message indicating that Your shopify keys are incorrect or not set. This means that you need to enter your Shopify Keys or revise them otherwise, Sku Grid will not be able to connect to your store.

Step 6: The first key is for your Shopify Store Url. 

Step 7: On your Shopify Dashboard, click the Eye Icon next to Online Store. This will open up your store's URL in another tab. Copy the URL that opens in the new tab. It will typically be in this format: https://mimis-discount-haven.myshopify.com/

Step 8: Right Click and paste your Shopify Store URL in the Shopify Store URL field.

Step 9: Next is your Shopify API Key. You will get this from your Private App Settings from the App you created in the previous tutorial.

Step 10: Click the clipboard button to copy your Shopify API Key.

Step 11: Right Click and Paste in your Shopify API Key in the Shopify API Key field.

Step 12: Next is your Shopify Password.

Step 13: Click the clipboard icon to copy your Shopify Password.

Step 14: Right Click & Paste in your Shopify Password into the Shopify Password field.

Step 15: Click Save Settings

Step 16: You'll see an alert that says your settings were saved.  To confirm, go back and Click Marketplaces again.

Step 17: Click Shopify

Step 18: Click US or the Country You're Selling on.

Step 19: You'll see that all of your Shopify Keys have been saved and the red error message about the keys not being set is now gone.

Step 20: That's it. You've successfully entered your Shopify Keys into Sku Grid.  Sku Grid will now have ability to connect to your Shopify Store to revise your items. Please continue to set up your marketplace settings and add your items to Sku Grid.

Here's an interactive tutorial for the visual learners

https://www.iorad.com/player/144692/Sku-Grid-Shopify-Repricer--How-to-Connect-Your-Shopify-Store-to-Sku-Grid




3. Configure Your Shopify Marketplace Settings




Step 1: Once you're logged into Sku Grid, click Settings.

Step 2: Click Marketplaces

Step 3: Click Shopify

Step 4: Click US or whichever country you're selling on.

Step 5: Default Quantity - This is the default quantity for all of your Shopify listings. Note: You will have ability to set a different default quantity on items as you’re adding them to the grid if you do not want to use the default for specific item(s).

Step 6: Enter a numeric value for your Default Quantity here.

Step 7: The next option is Update Sold Items to Default Quantity. After you get sales, do you want Sku Grid to bring your items back up to your default quantity?

Step 8: Select Yes or No here.

Step 9: Select Yes

Step 10: Reprice only if price increased by at least $.  This setting keeps Sku Grid from changing your price until the supplier price increases by the amount you set here.

Step 11: Enter a Numeric Value here. This should not be left at 0.

Step 12: Reprice only if price decreased by at least $. This setting keeps Sku Grid from changing your price downwards until the supplier price decreases by the amount you set here.

Step 13: Enter a Numeric Value Here.  This should not be left at 0. If you do not want Sku Grid to ever decrease your prices based on supplier changes, enter five 9's here.

Step 14: Set price to be rounded to the following cents: If you want Sku Grid to round your numbers, you can select any number here or choose Do Not Round Up, if you do not want Sku Grid to round your listing amounts.

Step 15: For this example, we will Click Do not round up

Step 16: Do not end OOS items, instead, change my price to... If you do not want your items ended/put OOS but would rather have your prices set high to discourage buying, you can enter a large number here, otherwise, leave it at 0 to not use this function.

Step 17: Type to disable this function.

Step 18: Auto Update Shopify Stock - If you want to allow Sku Grid to control or change your Shopify listing stock, then you need to enable this option. 

Step 19: Select Yes

Step 20: Only put items OOS (don't put them back in stock). If enabled, it keeps sku grid from restocking items that become available again at your supplier. Sku Grid would only be able to put items OOS and not back in stock.

Step 21: Select Disable if you do not want to use this feature.

Step 22: Auto Update Shopify Price.  If you want to allow Sku Grid to change your prices on your Shopify items in response to supplier price changes, then you would want to enable this option.

Step 23: Select Yes

Step 24: Import only products that exist in SG (to synchronize data) This option synchronizes data from Shopify to SG - if something went wrong during repricing, it would allow Sku Grid to go back and try to update the item again.

Step 25: Select Yes here.

Step 26: Import new products that do not exist in SG This option will allow Sku Grid to pull in your Shopify items into the grid if they don't already exist. They will be paused. You'll need to edit them, enter supplier urls, and unpause the items.

Step 27: Most people will want to Select Yes here. However, if you're selling a mix of dropshipped items and non-dropshipped items, then you would want to select No and you'd have to manually add the products you want to Sku Grid for tracking.

Step 28: Next, we'll move on to creating your selling price formula in the "Calculating Shopify's Selling Price" section.

Step 29: It's recommended to use the wizard to create your formulas. Click Switch To Wizard View.

Step 30: Vendor Tax (%) This is the amount that you want to mark up your item to account for sales tax that you'll have to pay your supplier. This is calculated based on supplier price.

Step 31: Enter a numeric value for vendor tax or leave it at 0 if you do not want to factor it into your pricing.

Step 32: Margin (%) This is percentage of your supplier price that you want to take home as profit after all fees are paid. This cannot be a negative number.

Step 33: Enter a numeric value for Margin % or leave it at 0 if you do not want to use this field.

Step 34: Fixed Margin $ This is the amount of profit you want to bring home in your currency in addition to the margin % mentioned above. You can use negative numbers here if desired.

Step 35: Enter a numeric value for Fixed Margin $ or set it to 0 to not use this field.

Step 36: Minimum Margin ($) This is the lowest profit margin that you want to bring home in the event that your margin % is low. Note: If you're working in dollar amounts instead of percents, then you will use equal fixed & minimum margins but not margin %.

Step 37: Enter a numeric value for Minimum Margin $ or enter a 0 if you do not want to use this field.

Step 38: PayPal/Shopify Fees (%) This field depends on what you're using as your payment processor on Shopify.  Shopify fees depend on the subscription plan chosen. Average fees are 2.9%.

Step 39: Enter a numeric value for PayPal/Shopify Fees % or enter a 0 if you do not want to use this field. Fees are calculated based on your selling price.

Step 40: PayPal/Shopify Fees ($) This is typically your transaction fee in dollar amounts.  The transaction fee for both PayPal and Shopify is 0.30 typically.

Step 41: Enter a numeric value for PayPal/Shopify Fees $ or set it to 0 if you do not want to use this field.

Step 42: Selling/Other Fees (%) This can be used to enter any other fees that you need to account for. It will be calculated based on your selling price.

Step 43: Enter a numeric value here for Selling/Other Fees % or set it to 0 if you do not want to use this field.

Step 44: Include Supplier's Shipping in Calculations - This is where you tell Sku Grid to factor in your supplier's shipping costs (if known) or not to.

Step 45: Select Yes if you want to include supplier's shipping in you calculations or No if you do not.

Step 46: Click Estimate Price

Step 47: Once the estimator opens, click OK to see what your selling price would be based on a supplier price of $100. If you're happy with the calculation, click to close it. Then Click Close to exit the wizard.

Step 48: You'll see that a long selling price formula has been created for you based on the values you entered in the wizard. Click Save Settings

Step 49: You will see an alert that says Settings were saved.

Step 50: That's it. You've successfully configured your Shopify Marketplace Settings.  Be sure that you have went through all other tabs of your settings - Here are videos going over those options - CLICK HERE

Here's an interactive tutorial for the visual learners

https://www.iorad.com/player/144696/Sku-Grid-Shopify-Repricer--Configuring-Your-Shopify-Marketplace-Settings



4. How to Add an Individual Shopify Item to Sku Grid



Step 1: The first step is to log into 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!

Here's an interactive tutorial for the visual learners

https://www.iorad.com/player/144718/Sku-Grid-Shopify-Repricer--How-to-Add-an-Individual-Shopify-Item-to-Sku-Grid




5. How to Import Your Shopify Items from Marketplace



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).

Here's an interactive tutorial for the visual learners

https://www.iorad.com/player/144725/Sku-Grid-Shopify-Repricer--How-to-Import-Your-Shopify-Items-via-Marketplace




6. How to Import Your Shopify Items Via CSV Into Sku Grid



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.

Here's an interactive tutorial for the visual learners

https://www.iorad.com/player/144807/Sku-Grid-Shopify-Repricer--How-to-Import-Your-Shopify-Items-Via-CSV-into-Sku-Grid