SevenBit

Upload, translation and download tool for eBay's REST API.

SKU Wash Codes

SKUs (SK-NNNNNN) are obfuscated into 5-character hex wash codes for external use. Use these Excel formulas to convert between them.

Assumes the SKU is in cell A1

=DEC2HEX(MOD(234571*VALUE(MID(A1,4,100))+517834,1000000),5)

Assumes the wash code is in cell B1

="SK-"&TEXT(MOD(167331*(HEX2DEC(B1)-517834),1000000),"000000")

Input	Output
`SK-000001`	`B7B15`
`B7B15`	`SK-000001`

pip install -r requirements.txt
python __main__.py