Maximize your business with Shopify and Ruby experience

Wang Wei

>>>>> The Goals
- Customers can purchase products with a map they customized
- Customize product detail page

>>>>> The Steps
Customers can click the interactive map or the list of countries below it to mark where they've traveled. 
When finished, click SAVE YOUR MAP. Customers will be prompted to log in or create an account first. 
Once their map is saved, continue to Step 2 where they'll select the product to apply their map into it.

>>>>> Technologies
- Platform: Shopify, Shopify Plus
- Shopify Theme Customization: Liquid
- Shopify App Development: Ruby on Rails, React.js, Vue.js, Shopify GraphQL/REST Admin API
- Tools: Shopify Theme kit, Slate

Shopify Theme Development

>>>>> The Goals
- Customers can customize the product by adding any Strap they want with their favorite color
- Customize product list page
- Customize product detail page

>>>>> Technologies

- Platform: Shopify, Shopify Plus
- Shopify Theme Customization: Liquid
- Shopify App Development: Ruby on Rails, React.js, Vue.js, Shopify GraphQL/REST Admin API
- Tools: Shopify Theme kit, Slate

The client wants to build the App which works as middleware between the Shopify store and their 3rd party server.

>>>>> Key features
- Parse the product CSV file from the FTP server and create new products and update existing products: 2 times every day
- Parse the note CSV file from the FTP server and fulfill and refund orders: 2 times every day
- Parse the inventory CSV file from the FTP server and update products inventories: 2 times every day
- Get new orders in between every 1 hr and export to CSVs into the FTP server
- Send the emails when it is failed to do the above steps
- Set times for a schedule

>>>>> Tech Stacks
Ruby on Rails, React Polaris, PostgreSQL, Sidekiq, Redis, Shopify GraphQL Admin API, AWS S3, smarter_csv gem, net/sftp gem, SendGrid, Heroku

>>>>> Challenge part
- Sometimes, the App got an R14(Memory Quota Exceed) error on the Heroku.
  It happened because there are 20~#0k rows in each CSV file and I have used csv gem.
  I have updated using smarter_csv gem and the error was gone
- Sometimes, the App reached the Shopify API limit because it calls Shopify APIs frequently.
  While updating inventory quantity, I have updated each product quantity.
  There were 20k~30k SKUs in the CSV, so this means it needs 20~30k Shopify API calls which are not a good way.
  I have updated using Shopify bulkInventoryQuantityUpdate mutation and it updated 100 SKUs in one API call.
  So the API limit issue was gone.

Shopify App Development

[ Easy Scheduler App ]

>>>>> The Goals
- Filter products by in-stock, out-stock
- Filter products by tags
- Filter products by product title
- Easy schedule to enable/disable products
- Easy schedule to add/remove to products

>>>>> Technologies

- Platform: Shopify, Shopify Plus
- Shopify App Development: Ruby on Rails, React.js, Shopify GraphQL Admin API
- Database: PostgreSQL
- Hosting: Heroku

Personal details

Wang W.

Summary

Technical skills

Personal Projects