You should have a Shopify account and relevant inventory data.
Note: RFID4U provides a template to users by email. This template contains three sheets: Product Export, Inventory Export, and Reference File.
Step 1 :- Click on the Inventory option , you will redirect to the Inventory page.
Step 2 :- Click on the Export option available on the right side of the page.
Step 3 :- After clicking on the Export option, a new window will pop up. In this window, you need to choose options such as 'All Quantity Types,' 'All Variants,' and 'Export as CSV for Excel/Numbers. Then Click on the “ Export Variant ” option.
Step 4 :- Open the exported file, copy the data, and paste it into the template file we provided, specifically the 'Inventory’' sheet.
Step 1 :- Click on the Product option , you will redirect to the Product page.
Step 2 :- Click on the Export option available on the right side of the page.
Step 3 :- After clicking on the Export option, a new window will pop up. In this window, you need to choose options such as 'All Products,' and 'Export as CSV for Excel/Numbers and Click on the Export Products option.
Step 4 :- Open the exported file, copy the data, and paste it into the template file we provided, specifically the ‘ Products ’ sheet.
Step 1 :- Open the template file (where you have already pasted the product and inventory data).
Step 2 :- Then In the Template , go to the Reference File sheet.
Step 3 :- Click on the extension button , and go to Macros.
Step 4 :- Click on the “ Update Reference ”.
Step 5 :- After clicking on the Update Reference option, the Reference File will be generated. Then, we need to download the same sheet in CSV format. ”.
Step 1 :- Open TagMatiks Wedge Application and log into the application.
Step 2 :- Click on the “ Application Configuration ” option.
Step 3 :- Click on the “ Reference File ” option.
Step 4 :- Click on the “ Browse File ” option to browse your reference file.
Step 5 :- Select the Reference file.
Step 6 :- Click on the “ Header Mapping ” option.
Step 7 :- Select the system field as GTIN .
Step 8 :- Select the reference field as Variant SKU.
Step 9 :- Click on the “ Add ” button.
Step 10 :- Click on the “ Save ” button.
Note : After saving the setting for the reference file, it will redirect to the Inventory Configuration page .
Step 11 :- Select the fields you want to display on the TagMatiks Wedge Application after the inventory.
Step 12 :- Click on the field dropdown option and choose the details you want on the TagMatiks Wedge page.
Suggestions for choosing fields:
• Handle
• Title
• Variant SKU
Step 13 :- Click on the “ Save ” button.
Export Configuration in TagMatiks Wedge Application:
Step 1 :- Open the TagMatiks Wedge Application and log into the application.
Step 2 :- Click on the “ Application Configuration ” option.
Step 3 :- Click on the “ Export Configuration ” option.
Step 4 :- Select the Export type as CSV as Shopify accepts only CSV format.
Step 5 :- Enter the file prefix.
Step 6 :- Click on the “ Field Settings ” option, swipe left to right , and click on the edit icon.
Step 7 :- Select the fields you want to see in your export file. Suggested fields are:
• Handle
• Title
• Option 1 Name
• Option 1 Value
• Option 2 Value
• Option 2 Value
• Option 3 Value
• Option 3 Value
• SKU
• Location
• Available
• On Hand
Step 8 :- Click on the ✔️ icon (upper right corner).
Step 9 :- Go back to the export configuration page and click on the ✔️ icon (upper right corner).
Step 1 :- Click on the “ Application Configuration ” option.
Step 2 :- Click on the “Filters” option.
Step 3 :- Select the “EPC” option in the memory bank option.
Step 4 :- Choose the “GS1” option.
Step 5 :- Click on the dropdown menu and choose the “SGTIN” option.
Step 6 :- Click on the “Save Filter” option to save the settings.
Step 1 :- Click on the "Inventory" option from the home page of the application.
Step 2 :- Click the '+' icon at the bottom right to create a new inventory.
Step 3 :- Click on the "Scan" soft button or press the hard trigger to take the inventory.
Step 4 :- Click on the "Stop" button to stop taking inventory.
Step 5 :- Click on the "Export" option (bottom right side).
Step 6 :- Click on the "Export as CSV" option.
Step 7 :- Select the location where you want to save the export file.
First, you need to modify the export file with simple steps so that it can be imported easily.
1. First, move the export file to your system and open it in Excel or a spreadsheet program.
2. Delete the File Header from row 1st to row 8th.
3. Copy the values from the Quantity column and paste them into the Available and On Hand columns. Then delete the Quantity column.
4. Save the file in CSV format.
Now, switch back to Shopify to import your inventory.
Step 1 :- Open Shopify and log in.
Step 2 :- Click on the Inventory option, and then click on the 'Import' option in the upper right.
Step 3 :- Click on the "Add file" option.
Step 4 :- Select the Inventory export file.
Step 5 :- Click on the "Upload and preview" option.
Step 6 :- Click on the "Start Import" option.
You can see the imported items in Shopify as illustrated in the image above.
