Discussion Forum: Thread 278318

 Author: thirteeneighty View Messages Posted By thirteeneighty
 Posted: Nov 14, 2020 10:13
 Subject: Bricklink wordpress integration (woocommerce)
 Viewed: 129 times
 Topic: Suggestions
 Status:Open
 Vote:[Yes|No]
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

thirteeneighty (1358)

Location:  United Kingdom, England
Member Since Contact Type Status
Nov 3, 2012 Member Does Not Allow Contact Seller
Buying Privileges - OKSelling Privileges - OK
Store: Bricktraders
As a business with both bricks 'n' mortar and online shop I'd love
to do sales direct though our own website (wordpress with woo-commerce) but manage
inventory, sales process, feedback etc on bricklink. Obviously I'd expect
to pay bricklink fees on these sales.

We have tried to run our own woo-commerce site manually as well as a bricklink
site but the admin required especially when we usually have small volumes of
many products meant that we abandoned these options and returned to simply selling
via bricklink where listing and inventory management is quick and easy.

If I could install a bricklink plugin on my woo / wordpress site and let that
process sales to bricklink, maintain inventory, images etc I would generate more
sales and bricklink would get more revenue. I guess it needs bricklink to develop
a plugin.

Would others be interested in such a plugin to allow them to make bricklink sales
off bricklink on their own sites?
 Author: Teup View Messages Posted By Teup
 Posted: Nov 14, 2020 10:26
 Subject: Re: Bricklink wordpress integration (woocommerce)
 Viewed: 56 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Teup (6590)

Location:  Netherlands, Utrecht
Member Since Contact Type Status
May 6, 2004 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: BLOKJESKONING
In Suggestions, thirteeneighty writes:
  As a business with both bricks 'n' mortar and online shop I'd love
to do sales direct though our own website (wordpress with woo-commerce) but manage
inventory, sales process, feedback etc on bricklink. Obviously I'd expect
to pay bricklink fees on these sales.

We have tried to run our own woo-commerce site manually as well as a bricklink
site but the admin required especially when we usually have small volumes of
many products meant that we abandoned these options and returned to simply selling
via bricklink where listing and inventory management is quick and easy.

If I could install a bricklink plugin on my woo / wordpress site and let that
process sales to bricklink, maintain inventory, images etc I would generate more
sales and bricklink would get more revenue. I guess it needs bricklink to develop
a plugin.

Would others be interested in such a plugin to allow them to make bricklink sales
off bricklink on their own sites?

I have this, my woocommerce webshop is synced to my Bricklink. It auto generates
new products as well and downloads their pictures from Rebrickable whenever I
part out something on Bricklink. It took me about two solid months of programming
to get it done. As it's completely tailor-made and integrated with my administration
software I can't exactly share it, besides the fact that it may not be stable
enough to really be a third party tool...
All I can say is, if you want to get this done, it's gonna be quite a project!
 Author: 3001Bricks View Messages Posted By 3001Bricks
 Posted: Nov 14, 2020 11:45
 Subject: Re: Bricklink wordpress integration (woocommerce)
 Viewed: 40 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

3001Bricks (2422)

Location:  USA, Arkansas
Member Since Contact Type Status
Dec 30, 2015 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: 3001Bricks
In Suggestions, Teup writes:
  In Suggestions, thirteeneighty writes:
  As a business with both bricks 'n' mortar and online shop I'd love
to do sales direct though our own website (wordpress with woo-commerce) but manage
inventory, sales process, feedback etc on bricklink. Obviously I'd expect
to pay bricklink fees on these sales.

We have tried to run our own woo-commerce site manually as well as a bricklink
site but the admin required especially when we usually have small volumes of
many products meant that we abandoned these options and returned to simply selling
via bricklink where listing and inventory management is quick and easy.

If I could install a bricklink plugin on my woo / wordpress site and let that
process sales to bricklink, maintain inventory, images etc I would generate more
sales and bricklink would get more revenue. I guess it needs bricklink to develop
a plugin.

Would others be interested in such a plugin to allow them to make bricklink sales
off bricklink on their own sites?

I have this, my woocommerce webshop is synced to my Bricklink. It auto generates
new products as well and downloads their pictures from Rebrickable whenever I
part out something on Bricklink. It took me about two solid months of programming
to get it done. As it's completely tailor-made and integrated with my administration
software I can't exactly share it, besides the fact that it may not be stable
enough to really be a third party tool...
All I can say is, if you want to get this done, it's gonna be quite a project!


Would you be willing to share to rough route you've taken? What pulls from
where, did you do most programming on the woocommerce side of things?

Thanks!
 Author: Teup View Messages Posted By Teup
 Posted: Nov 14, 2020 12:14
 Subject: Re: Bricklink wordpress integration (woocommerce)
 Viewed: 73 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Teup (6590)

Location:  Netherlands, Utrecht
Member Since Contact Type Status
May 6, 2004 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: BLOKJESKONING
In Suggestions, Gmid writes:
  In Suggestions, Teup writes:
  In Suggestions, thirteeneighty writes:
  As a business with both bricks 'n' mortar and online shop I'd love
to do sales direct though our own website (wordpress with woo-commerce) but manage
inventory, sales process, feedback etc on bricklink. Obviously I'd expect
to pay bricklink fees on these sales.

We have tried to run our own woo-commerce site manually as well as a bricklink
site but the admin required especially when we usually have small volumes of
many products meant that we abandoned these options and returned to simply selling
via bricklink where listing and inventory management is quick and easy.

If I could install a bricklink plugin on my woo / wordpress site and let that
process sales to bricklink, maintain inventory, images etc I would generate more
sales and bricklink would get more revenue. I guess it needs bricklink to develop
a plugin.

Would others be interested in such a plugin to allow them to make bricklink sales
off bricklink on their own sites?

I have this, my woocommerce webshop is synced to my Bricklink. It auto generates
new products as well and downloads their pictures from Rebrickable whenever I
part out something on Bricklink. It took me about two solid months of programming
to get it done. As it's completely tailor-made and integrated with my administration
software I can't exactly share it, besides the fact that it may not be stable
enough to really be a third party tool...
All I can say is, if you want to get this done, it's gonna be quite a project!


Would you be willing to share to rough route you've taken? What pulls from
where, did you do most programming on the woocommerce side of things?

Thanks!

I only know C#, so it's not all fancy and integrated but basically a framework
built around what Woocommerce already is.


Syncing to Woocommerce:
Woocommerce takes two kinds of imports: New products, or updating existing products.
So, the core of what I did was basically make something that can turn a Bricklink
inventory into both of these things. It keeps a log of what items were already
exported in the past so it knows:
- which lots are already up to date (Woocommerce import is slow, and easily crashes,
so better not to update anything that isn't necessary!) = no export
- which lots have changed quantity, price, or remarks = update existing product
csv
- which lots are completely new = new product csv, drawing the data from my catalog
text file and Rebrickable for the picture.

For the actual product SKU's I use part number + colour number. That works
for me as I don't have multiple lots of the same part/colour combination.
So whenever a part/colour combination has a new quantity, a new BL lot ID, a
new remark, or a new price, it gets an update from that update csv.


Syncing back to BL:
For this I needed to tweak Woocommerce to display the BL Lot IDs in my picking
list (paid a programmer to do it). I just copy the entire picking list to the
clipboard, press New Order in my software, and it populates everything for my
invoice and knows which lots need which amount substracted. Then it does so via
the API.

So I just download my BL inventory each day, convert it to an inventory update
csv, and import it in Woocommerce. Sync in the other direction is automatic.
Slight chance that people buy the same on both platforms, but I can live with
that.
 Author: Oakelm View Messages Posted By Oakelm
 Posted: Nov 14, 2020 11:35
 Subject: Re: Bricklink wordpress integration (woocommerce)
 Viewed: 51 times
 Topic: Suggestions
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Oakelm (804)

Location:  United Kingdom, England
Member Since Contact Type Status
Oct 3, 2017 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: OAKELM
In Suggestions, thirteeneighty writes:
  As a business with both bricks 'n' mortar and online shop I'd love
to do sales direct though our own website (wordpress with woo-commerce) but manage
inventory, sales process, feedback etc on bricklink. Obviously I'd expect
to pay bricklink fees on these sales.

We have tried to run our own woo-commerce site manually as well as a bricklink
site but the admin required especially when we usually have small volumes of
many products meant that we abandoned these options and returned to simply selling
via bricklink where listing and inventory management is quick and easy.

If I could install a bricklink plugin on my woo / wordpress site and let that
process sales to bricklink, maintain inventory, images etc I would generate more
sales and bricklink would get more revenue. I guess it needs bricklink to develop
a plugin.

Would others be interested in such a plugin to allow them to make bricklink sales
off bricklink on their own sites?

Voted yes, have no use for it yet but nmaybe one day. However you might be quicker
to talk to the guy running BrickFreedom, already doing integrations for BrickLink
to the bird place but also there is post integration and from the chats expect
it to expand into a more bespoke that could in theory do ebay as well so wordpress
not a big extra step and they are UK based. Im sure for the right incentive they
would consider it as im guessing you not the only one wanting this so they have
something to market at the end of the work, your just the guinea pig.