search

vitalseeds / vs-data-api

Fast API endpoints to expose vs-data actions for to run from Filemaker
MIT License
0 stars 0 forks source link

Large variety product variation SKUs lowercased on live WC store #30

Closed tombola closed 11 months ago

tombola commented 11 months ago

Eg OnWl-GR is now onwl-GR.

Unknown how this happened, though suspicious that SQL in vs-data uses LOWER to do case insensitive sku comparison. Weirdly though, it is Filemaker that appends a -GR to skus, so the fact that remains uppercase implies that the actual upload was by/post Filemaker.

Anyway, for now just need to correct every large variation sku using WC API.

tombola commented 11 months ago

Usefully, the regular product variation remains capitalised, so can use that to reconstruct (add -GR)

tombola commented 11 months ago

This was solved by running one off command from this branch from dev machine

https://github.com/vitalseeds/vs-data-api/tree/30-recapitalise-skus